APPS.IGS_PS_RLOVR_FAC_TSK dependencies on IGS_PS_USO_CLAS_MEET

Line 202: NOT EXISTS (SELECT 'x' FROM igs_ps_uso_clas_meet ucm

198: ( (TO_DATE(TO_CHAR(uso.start_time,'HH24:MI'),'HH24:MI') <> cp_end_time) AND
199: (TO_DATE(TO_CHAR(uso.end_time,'HH24:MI'),'HH24:MI') <> cp_start_time )
200: ) AND
201: NVL(uso.to_be_announced,'N') = 'N' AND
202: NOT EXISTS (SELECT 'x' FROM igs_ps_uso_clas_meet ucm
203: WHERE ucm.uoo_id = uso.uoo_id ) AND
204: NOT EXISTS (SELECT 'x' FROM igs_ps_usec_x_grpmem uxg
205: WHERE uxg.uoo_id = uso.uoo_id)
206: ORDER BY uso.row_id asc;