APPS.IGS_IN_GEN_001 dependencies on IGS_PE_PERS_ENCUMB

Line 136: FROM IGS_PE_PERS_ENCUMB pen,

132: SELECT pen.person_id,
133: pen.encumbrance_type,
134: pen.start_dt,
135: et.s_encumbrance_cat
136: FROM IGS_PE_PERS_ENCUMB pen,
137: IGS_FI_ENCMB_TYPE et
138: WHERE pen.person_id = p_person_id AND
139: pen.start_dt <= p_effective_dt AND
140: (pen.expiry_dt IS NULL OR

Line 144: cp_person_id IGS_PE_PERS_ENCUMB.person_id%TYPE,

140: (pen.expiry_dt IS NULL OR
141: pen.expiry_dt > p_effective_dt) AND
142: et.encumbrance_type = pen.encumbrance_type;
143: CURSOR c_pee (
144: cp_person_id IGS_PE_PERS_ENCUMB.person_id%TYPE,
145: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
146: cp_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE) IS
147: SELECT pee.course_cd,
148: pee.person_id,

Line 145: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,

141: pen.expiry_dt > p_effective_dt) AND
142: et.encumbrance_type = pen.encumbrance_type;
143: CURSOR c_pee (
144: cp_person_id IGS_PE_PERS_ENCUMB.person_id%TYPE,
145: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
146: cp_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE) IS
147: SELECT pee.course_cd,
148: pee.person_id,
149: pee.encumbrance_type,

Line 146: cp_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE) IS

142: et.encumbrance_type = pen.encumbrance_type;
143: CURSOR c_pee (
144: cp_person_id IGS_PE_PERS_ENCUMB.person_id%TYPE,
145: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
146: cp_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE) IS
147: SELECT pee.course_cd,
148: pee.person_id,
149: pee.encumbrance_type,
150: pee.pen_start_dt,