APPS.IGS_EN_GEN_007 dependencies on IGS_PE_TYP_INSTANCES_ALL

Line 25: replaced igs_pe_typ_instances with igs_pe_typ_instances_all.

21: /* change history
22: WHO WHEN WHAT
23: pkpatel 26-MAR-2003 Bug 2261717
24: Filter the query for efficiency. Removed the COUNT(*) and
25: replaced igs_pe_typ_instances with igs_pe_typ_instances_all.
26: stutta 31-MAR-2004 Bug 3518606, Changed cursor c_aa by not truncating the sysdate
27: for checking if the person is valid on the current day.
28:
29: */

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);