APPS.IGS_EN_GEN_011 dependencies on IGS_PE_COURSE_EXCL

Line 5485: IGS_PE_COURSE_EXCL.*

5481: expiry_dt > p_expiry_dt)
5482: FOR UPDATE OF expiry_dt NOWAIT;
5483: CURSOR c_person_course_exclusion IS
5484: SELECT rowid,
5485: IGS_PE_COURSE_EXCL.*
5486: FROM IGS_PE_COURSE_EXCL
5487: WHERE
5488: person_id = p_person_id AND
5489: encumbrance_type = p_encumbrance_type AND

Line 5486: FROM IGS_PE_COURSE_EXCL

5482: FOR UPDATE OF expiry_dt NOWAIT;
5483: CURSOR c_person_course_exclusion IS
5484: SELECT rowid,
5485: IGS_PE_COURSE_EXCL.*
5486: FROM IGS_PE_COURSE_EXCL
5487: WHERE
5488: person_id = p_person_id AND
5489: encumbrance_type = p_encumbrance_type AND
5490: pen_start_dt = p_pen_start_dt AND

Line 5583: IGS_PE_COURSE_EXCL_PKG.UPDATE_ROW(

5579: INTO l_dcd_date
5580: FROM DUAL;
5581:
5582:
5583: IGS_PE_COURSE_EXCL_PKG.UPDATE_ROW(
5584: X_ROWID => v_pce_rec.ROWID ,
5585: X_PERSON_ID => v_pce_rec.PERSON_ID ,
5586: X_ENCUMBRANCE_TYPE => v_pce_rec.ENCUMBRANCE_TYPE ,
5587: X_PEN_START_DT => v_pce_rec.PEN_START_DT ,