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_GEN_007 dependencies on IGS_PE_PERSON

Line 38: CURSOR c_aa (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS

34: v_output VARCHAR2(1);
35:
36: -- (pathipat) Cursor c_aa modified for performance issues, Bug No: 2432563
37:
38: CURSOR c_aa (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
39: SELECT 1
40: FROM igs_pe_typ_instances_all pti, igs_pe_person_types pty
41: WHERE pti.person_type_code = pty.person_type_code AND
42: pty.system_type = 'STUDENT' AND

Line 40: FROM igs_pe_typ_instances_all pti, igs_pe_person_types pty

36: -- (pathipat) Cursor c_aa modified for performance issues, Bug No: 2432563
37:
38: CURSOR c_aa (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
39: SELECT 1
40: FROM igs_pe_typ_instances_all pti, igs_pe_person_types pty
41: WHERE pti.person_type_code = pty.person_type_code AND
42: pty.system_type = 'STUDENT' AND
43: pti.person_id = cp_person_id AND
44: sysdate BETWEEN start_date AND NVL(end_date,sysdate);