DBA Data[Home] [Help]

APPS.IGS_PE_PERS_ENCUMB_PKG dependencies on IGS_EN_ELGB_OVR_ALL

Line 107: FROM igs_pe_hold_rel_ovr hovr, igs_en_elgb_ovr_all ovr

103: vkarthik 16-Jul-2004 Added validation on hold start date and hold expiry date as part of Bug 3771317
104: ------------------------------------------------------------------*/
105: CURSOR cur_hold_ovr IS
106: SELECT hold_old_end_dt
107: FROM igs_pe_hold_rel_ovr hovr, igs_en_elgb_ovr_all ovr
108: WHERE ovr.elgb_override_id =hovr.elgb_override_id AND
109: ovr.person_id = new_references.person_id AND new_references.start_dt = hovr.start_date
110: AND new_references.encumbrance_type = hovr.hold_type;
111: