APPS.IGS_EN_VAL_PEN dependencies on IGS_FI_ENCMB_TYPE

Line 117: v_encmb_type_rec IGS_FI_ENCMB_TYPE%ROWTYPE;

113: RETURN BOOLEAN AS
114: BEGIN
115: DECLARE
116: v_psn_encmb_rec IGS_PE_PERS_ENCUMB%ROWTYPE;
117: v_encmb_type_rec IGS_FI_ENCMB_TYPE%ROWTYPE;
118: CURSOR c_psn_encmb_rec (
119: cp_person_id IGS_PE_PERS_ENCUMB.person_id%TYPE,
120: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
121: cp_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE) IS

Line 129: cp_encumbrance_type IGS_FI_ENCMB_TYPE.encumbrance_type%TYPE) IS

125: encumbrance_type = cp_encumbrance_type AND
126: start_dt <> cp_start_dt AND
127: expiry_dt IS NULL;
128: CURSOR c_encmb_type_rec (
129: cp_encumbrance_type IGS_FI_ENCMB_TYPE.encumbrance_type%TYPE) IS
130: SELECT *
131: FROM IGS_FI_ENCMB_TYPE
132: WHERE encumbrance_type = cp_encumbrance_type AND
133: s_encumbrance_cat = 'ADMIN';

Line 131: FROM IGS_FI_ENCMB_TYPE

127: expiry_dt IS NULL;
128: CURSOR c_encmb_type_rec (
129: cp_encumbrance_type IGS_FI_ENCMB_TYPE.encumbrance_type%TYPE) IS
130: SELECT *
131: FROM IGS_FI_ENCMB_TYPE
132: WHERE encumbrance_type = cp_encumbrance_type AND
133: s_encumbrance_cat = 'ADMIN';
134: BEGIN
135: -- This module checks if there are no other