eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_ELGBL_PERSON dependencies on IGS_PE_HOLD_REL_OVR

Line 159: cp_hold_type igs_pe_hold_rel_ovr.hold_type%TYPE) IS

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
163: WHERE eoa.elgb_override_id = hro.elgb_override_id

Line 162: igs_pe_hold_rel_ovr hro

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
166: AND eoa.ci_sequence_number = p_load_cal_sequence_number

Line 168: l_hold_override igs_pe_hold_rel_ovr.hold_rel_or_ovr%TYPE;

164: AND eoa.person_id = cp_person_id
165: AND eoa.cal_type = p_load_calendar_type
166: AND eoa.ci_sequence_number = p_load_cal_sequence_number
167: AND hro.hold_type = cp_hold_type;
168: l_hold_override igs_pe_hold_rel_ovr.hold_rel_or_ovr%TYPE;
169:
170: l_census_date DATE;
171:
172: BEGIN

Line 404: cp_hold_type igs_pe_hold_rel_ovr.hold_type%TYPE) IS

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
408: WHERE eoa.elgb_override_id = hro.elgb_override_id

Line 407: igs_pe_hold_rel_ovr hro

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
411: AND eoa.ci_sequence_number = p_load_cal_sequence_number

Line 413: l_hold_override igs_pe_hold_rel_ovr.hold_rel_or_ovr%TYPE;

409: AND eoa.person_id = cp_person_id
410: AND eoa.cal_type = p_load_calendar_type
411: AND eoa.ci_sequence_number = p_load_cal_sequence_number
412: AND hro.hold_type = cp_hold_type;
413: l_hold_override igs_pe_hold_rel_ovr.hold_rel_or_ovr%TYPE;
414:
415: l_message_name VARCHAR2(30);
416:
417: BEGIN