DBA Data[Home] [Help]

APPS.IGS_EN_GEN_005 dependencies on IGS_GE_DATE

Line 180: NVL(pur.expiry_dt, igs_ge_date.igsdate('9999/01/01')) > SYSDATE AND

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
182: pee.encumbrance_type = pur.encumbrance_type AND
183: pee.pen_start_dt = pur.pen_start_dt AND
184: pee.s_encmb_effect_type = pur.s_encmb_effect_type AND