/* Planned (Pending) Package operation details */
SELECT NVL(pl.operation, ' ') AS operation, pv.build_type
 FROM planned pl, package_versions pv
WHERE pl.PV_ID = :PV_ID
  AND pl.RTAG_ID = :RTAG_ID
  AND pv.pv_id = :PV_ID

