APPS.IGS_EN_GEN_012 dependencies on IGS_PE_TYP_INSTANCES_ALL

Line 1933: FROM igs_pe_typ_instances_all PTI,

1929: DECLARE
1930: CURSOR c1 IS
1931: --modified for performance bug 3699543
1932: SELECT 'X'
1933: FROM igs_pe_typ_instances_all PTI,
1934: IGS_PE_PERSON_TYPES PPT
1935: WHERE PPT.system_type = 'STUDENT' AND
1936: ppt.person_type_code = pti.person_type_code AND
1937: pti.COURSE_CD = v_sca_exists.COURSE_CD AND

Line 1966: FROM igs_pe_typ_instances_all ti

1962:
1963: DECLARE
1964: CURSOR c2 IS
1965: SELECT ROWID, ti.*
1966: FROM igs_pe_typ_instances_all ti
1967: WHERE course_cd = v_sca_exists.COURSE_CD AND
1968: person_id = v_sca_exists.PERSON_ID;
1969:
1970: l_rowid VARCHAR2(25);

Line 2265: FROM igs_pe_typ_instances_all PTI,

2261: DECLARE
2262: CURSOR c1 IS
2263: -- modified for perf bug 3699560
2264: SELECT 'X'
2265: FROM igs_pe_typ_instances_all PTI,
2266: IGS_PE_PERSON_TYPES PPT
2267: WHERE PPT.system_type = 'STUDENT' AND
2268: ppt.person_type_code = pti.person_type_code
2269: AND pti.COURSE_CD = c_ps_att_rec.COURSE_CD

Line 2297: FROM igs_pe_typ_instances_all ti

2293: IF c1%FOUND THEN
2294: DECLARE
2295: CURSOR c2 IS
2296: SELECT ROWID, ti.*
2297: FROM igs_pe_typ_instances_all ti
2298: WHERE course_cd = c_ps_att_rec.COURSE_CD
2299: AND person_id = c_ps_att_rec.PERSON_ID;
2300: l_rowid VARCHAR2(25);
2301: l_pk NUMBER(15);

Line 2699: FROM igs_pe_typ_instances_all PTI,

2695: DECLARE
2696: CURSOR c1 IS
2697: -- modified for perf bug 3699628
2698: SELECT 'X'
2699: FROM igs_pe_typ_instances_all PTI,
2700: IGS_PE_PERSON_TYPES PPT
2701: WHERE PPT.system_type = 'STUDENT' AND
2702: ppt.person_type_code = pti.person_type_code
2703: AND pti.COURSE_CD = c_enps_att_rec.COURSE_CD

Line 2730: FROM igs_pe_typ_instances_all ti

2726: DECLARE
2727:
2728: CURSOR c2 IS
2729: SELECT ROWID, ti.*
2730: FROM igs_pe_typ_instances_all ti
2731: WHERE course_cd = c_enps_att_rec.COURSE_CD
2732: AND person_id = c_enps_att_rec.PERSON_ID;
2733: l_rowid VARCHAR2(25);
2734: l_pk NUMBER(15);