DBA Data[Home] [Help]

APPS.IGS_EN_GEN_005 dependencies on IGS_PE_PERSENC_EFFCT

Line 177: IGS_PE_PERSENC_EFFCT pee

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
181: pee.person_id = pur.person_id AND