APPS.IGS_PS_RLOVR_FAC_TSK dependencies on IGS_PS_USEC_X_GRPMEM

Line 204: NOT EXISTS (SELECT 'x' FROM igs_ps_usec_x_grpmem uxg

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;
207:
208: --check if the conflicting record already exists in the temp table before inserting it.