APPS.IGS_EN_ELGBL_PERSON dependencies on IGS_EN_ELGB_OVR_ALL

Line 158: CURSOR c_hold_override (cp_person_id igs_en_elgb_ovr_all.person_id%TYPE,

154: --
155: -- cursor to check whether the particular hold type for a person in a given term/teaching period
156: -- is overridden or not
157: --
158: CURSOR c_hold_override (cp_person_id igs_en_elgb_ovr_all.person_id%TYPE,
159: cp_hold_type igs_pe_hold_rel_ovr.hold_type%TYPE) IS
160: SELECT hro.hold_rel_or_ovr
161: FROM igs_en_elgb_ovr_all eoa,
162: igs_pe_hold_rel_ovr hro

Line 161: FROM igs_en_elgb_ovr_all eoa,

157: --
158: CURSOR c_hold_override (cp_person_id igs_en_elgb_ovr_all.person_id%TYPE,
159: cp_hold_type igs_pe_hold_rel_ovr.hold_type%TYPE) IS
160: SELECT hro.hold_rel_or_ovr
161: FROM igs_en_elgb_ovr_all eoa,
162: igs_pe_hold_rel_ovr hro
163: WHERE eoa.elgb_override_id = hro.elgb_override_id
164: AND eoa.person_id = cp_person_id
165: AND eoa.cal_type = p_load_calendar_type

Line 403: CURSOR c_hold_override (cp_person_id igs_en_elgb_ovr_all.person_id%TYPE,

399: --
400: -- cursor to check whether the particular hold type for a person in a given term/teaching period
401: -- is overridden or not
402: --
403: CURSOR c_hold_override (cp_person_id igs_en_elgb_ovr_all.person_id%TYPE,
404: cp_hold_type igs_pe_hold_rel_ovr.hold_type%TYPE) IS
405: SELECT hro.hold_rel_or_ovr
406: FROM igs_en_elgb_ovr_all eoa,
407: igs_pe_hold_rel_ovr hro

Line 406: FROM igs_en_elgb_ovr_all eoa,

402: --
403: CURSOR c_hold_override (cp_person_id igs_en_elgb_ovr_all.person_id%TYPE,
404: cp_hold_type igs_pe_hold_rel_ovr.hold_type%TYPE) IS
405: SELECT hro.hold_rel_or_ovr
406: FROM igs_en_elgb_ovr_all eoa,
407: igs_pe_hold_rel_ovr hro
408: WHERE eoa.elgb_override_id = hro.elgb_override_id
409: AND eoa.person_id = cp_person_id
410: AND eoa.cal_type = p_load_calendar_type