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.

[Home] [Help]

APPS.IGS_EN_ELGBL_PERSON dependencies on IGS_PE_PERS_ENCUMB

Line 140: CURSOR c_holds (cp_person_id igs_pe_pers_encumb.person_id%TYPE) IS

136: --
137: -- cursor to fecth all the holds of the student which has the hold effect of Deny all
138: -- enrolment activity
139: --
140: CURSOR c_holds (cp_person_id igs_pe_pers_encumb.person_id%TYPE) IS
141: SELECT ppe.person_id,
142: ppe.encumbrance_type,
143: peff.pee_start_dt hold_start_dt,
144: peff.expiry_dt

Line 145: FROM igs_pe_pers_encumb ppe,

141: SELECT ppe.person_id,
142: ppe.encumbrance_type,
143: peff.pee_start_dt hold_start_dt,
144: peff.expiry_dt
145: FROM igs_pe_pers_encumb ppe,
146: igs_pe_persenc_effct peff
147: WHERE ppe.person_id = peff.person_id
148: AND ppe.encumbrance_type = peff.encumbrance_type
149: AND ppe.start_dt=peff.pen_start_dt

Line 392: FROM igs_pe_pers_encumb ppe,

388: SELECT ppe.person_id,
389: ppe.encumbrance_type,
390: peff.pee_start_dt hold_start_dt,
391: peff.expiry_dt
392: FROM igs_pe_pers_encumb ppe,
393: IGS_PE_PERSENC_EFFCT peff
394: WHERE ppe.encumbrance_type = peff.encumbrance_type
395: AND ppe.start_dt=peff.pen_start_dt
396: AND s_encmb_effect_type in ('SUS_SRVC','RVK_SRVC')