APPS.IGS_PE_PERSENC_EFFCT_PKG dependencies on IGS_PE_HOLD_REL_OVR

Line 154: FROM igs_pe_hold_rel_ovr HOVR, IGS_EN_ELGB_OVR_ALL OVR

150: ) AS
151:
152: CURSOR cur_hold_ovr IS
153: SELECT HOLD_OLD_END_DT
154: FROM igs_pe_hold_rel_ovr HOVR, IGS_EN_ELGB_OVR_ALL OVR
155: WHERE OVR.ELGB_OVERRIDE_ID =HOVR.ELGB_OVERRIDE_ID AND
156: OVR.PERSON_ID = new_references.PERSON_ID AND new_references.pee_start_dt = HOVR.START_DATE
157: AND new_references.encumbrance_typE = HOVR.HOLD_TYPE;
158: