APPS.IGS_EN_GEN_005 dependencies on IGS_PE_UNT_REQUIRMNT

Line 176: FROM IGS_PE_UNT_REQUIRMNT pur,

172: asul.s_adv_stnd_granting_status IN (cst_granted,
173: cst_approved);
174: CURSOR c_pur_pee IS
175: SELECT 'X'
176: FROM IGS_PE_UNT_REQUIRMNT pur,
177: IGS_PE_PERSENC_EFFCT pee
178: WHERE pur.person_id = p_person_id AND
179: pur.pur_start_dt <= SYSDATE AND
180: NVL(pur.expiry_dt, igs_ge_date.igsdate('9999/01/01')) > SYSDATE AND