APPS.IGF_AW_GEN_005 dependencies on IGS_PE_PERS_ENCUMB

Line 371: igs_pe_pers_encumb enc,

367: cp_date DATE
368: ) IS
369: SELECT eff.encumbrance_type encb_type, eff.s_encmb_effect_type effect_type
370: FROM igs_fi_encmb_type typ,
371: igs_pe_pers_encumb enc,
372: igs_pe_persenc_effct eff
373: WHERE typ.s_encumbrance_cat = 'ACADEMIC'
374: AND typ.encumbrance_type = enc.encumbrance_type
375: AND NVL(cp_date, TRUNC(sysdate)) BETWEEN TRUNC(eff.pee_start_dt) AND NVL(TRUNC(eff.expiry_dt), TRUNC(sysdate))