APPS.IGS_PE_GEN_002 dependencies on IGS_FI_ENCMB_TYPE

Line 230: CURSOR c_hold_typ_exst(cp_encumbrance_type igs_fi_encmb_type.encumbrance_type%TYPE) IS

226: WHERE
227: person_number = cp_person_number;
228:
229: -- hold type exists check cursor
230: CURSOR c_hold_typ_exst(cp_encumbrance_type igs_fi_encmb_type.encumbrance_type%TYPE) IS
231: SELECT
232: 'X'
233: FROM
234: igs_fi_encmb_type

Line 234: igs_fi_encmb_type

230: CURSOR c_hold_typ_exst(cp_encumbrance_type igs_fi_encmb_type.encumbrance_type%TYPE) IS
231: SELECT
232: 'X'
233: FROM
234: igs_fi_encmb_type
235: WHERE
236: encumbrance_type = cp_encumbrance_type AND
237: s_encumbrance_cat = 'ADMIN';
238: