APPS.IGS_EN_STDNT_PS_ATT_PKG dependencies on IGS_PE_TYP_INSTANCES_ALL

Line 896: FROM igs_pe_typ_instances_all pti

892: */
893: --modified cursor for perf bug 3696781
894: CURSOR cur_typ_id_inst(p_PERSON_ID NUMBER,p_COURSE_CD VARCHAR2,p_PERSON_TYPE_CODE VARCHAR2) IS
895: SELECT pti.*
896: FROM igs_pe_typ_instances_all pti
897: WHERE pti.PERSON_ID = p_PERSON_ID AND
898: pti.COURSE_CD = p_COURSE_CD AND
899: pti.PERSON_TYPE_CODE = p_PERSON_TYPE_CODE AND
900: pti.END_DATE IS NULL;

Line 915: FROM igs_pe_typ_instances_all pti,

911: CURSOR cur_pe_typ_inst( p_person_id igs_pe_typ_instances.PERSON_ID%TYPE,
912: p_course_cd igs_pe_typ_instances.course_cd%TYPE,
913: p_system_type igs_pe_person_types.SYSTEM_TYPE%TYPE) IS
914: SELECT pti.rowid row_id ,pti.*
915: FROM igs_pe_typ_instances_all pti,
916: igs_pe_person_types pty
917: WHERE pti.person_id = p_person_id AND
918: pti.course_cd = p_course_cd AND
919: pti.end_date IS NULL AND