APPS.IGF_AW_GEN_005 dependencies on IGS_PE_PERSENC_EFFCT

Line 348: cp_encb_type igs_pe_persenc_effct.encumbrance_type%TYPE,

344: -- Check whether the fund is present in Persons Exclusiions list
345: CURSOR c_chk_fund(
346: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
347: cp_fund_code igf_aw_fund_mast_all.fund_code%TYPE,
348: cp_encb_type igs_pe_persenc_effct.encumbrance_type%TYPE,
349: cp_effect_type VARCHAR2,
350: cp_date DATE
351: ) IS
352: SELECT 'x'

Line 372: igs_pe_persenc_effct eff

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))
376: AND enc.person_id = cp_person_id