DBA Data[Home] [Help]

APPS.IGF_AP_OSS_INTEGR dependencies on IGS_FI_ENCMB_TYPE

Line 103: FROM igs_pe_pers_encumb holdtyp,igs_fi_encmb_type b, igs_pe_persenc_effct holdefft

99:
100: CURSOR c_get_holds IS
101: SELECT holdtyp.encumbrance_type encumbrance_type,
102: b.description dsp_description
103: FROM igs_pe_pers_encumb holdtyp,igs_fi_encmb_type b, igs_pe_persenc_effct holdefft
104: WHERE holdtyp.person_id = p_person_id
105: AND b.encumbrance_type = holdtyp.encumbrance_type
106: AND holdtyp.start_dt <= TRUNC(SYSDATE)
107: AND ( holdtyp.expiry_dt >= TRUNC(SYSDATE)