APPS.IGS_EN_GEN_012 dependencies on IGS_PE_PERSON_TYPES

Line 1934: IGS_PE_PERSON_TYPES PPT

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
1938: pti.PERSON_ID = v_sca_exists.PERSON_ID;

Line 1944: FROM igs_pe_person_types

1940: c1_rec c1%ROWTYPE;
1941:
1942: CURSOR c_former_stdnt IS
1943: SELECT person_type_code
1944: FROM igs_pe_person_types
1945: WHERE system_type = 'FORMER_STUDENT';
1946:
1947: l_person_type_code igs_pe_person_types.person_type_code%TYPE := NULL;
1948:

Line 1947: l_person_type_code igs_pe_person_types.person_type_code%TYPE := NULL;

1943: SELECT person_type_code
1944: FROM igs_pe_person_types
1945: WHERE system_type = 'FORMER_STUDENT';
1946:
1947: l_person_type_code igs_pe_person_types.person_type_code%TYPE := NULL;
1948:
1949: l_rowid VARCHAR2(25);
1950: l_pk NUMBER(15);
1951: l_org_id NUMBER := igs_ge_gen_003.get_org_id;

Line 2266: IGS_PE_PERSON_TYPES PPT

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
2270: AND pti.PERSON_ID = c_ps_att_rec.PERSON_ID;

Line 2276: FROM igs_pe_person_types

2272: c1_rec c1%ROWTYPE;
2273:
2274: CURSOR c_former_stdnt IS
2275: SELECT person_type_code
2276: FROM igs_pe_person_types
2277: WHERE system_type = 'FORMER_STUDENT';
2278:
2279: l_person_type_code igs_pe_person_types.person_type_code%TYPE := NULL;
2280:

Line 2279: l_person_type_code igs_pe_person_types.person_type_code%TYPE := NULL;

2275: SELECT person_type_code
2276: FROM igs_pe_person_types
2277: WHERE system_type = 'FORMER_STUDENT';
2278:
2279: l_person_type_code igs_pe_person_types.person_type_code%TYPE := NULL;
2280:
2281:
2282: l_rowid VARCHAR2(25);
2283: l_pk NUMBER(15);

Line 2700: IGS_PE_PERSON_TYPES PPT

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
2704: AND pti.PERSON_ID = c_enps_att_rec.PERSON_ID;

Line 2709: FROM igs_pe_person_types

2705: c1_rec c1%ROWTYPE;
2706:
2707: CURSOR c_former_stdnt IS
2708: SELECT person_type_code
2709: FROM igs_pe_person_types
2710: WHERE system_type = 'FORMER_STUDENT';
2711:
2712: l_person_type_code igs_pe_person_types.person_type_code%TYPE := NULL;
2713:

Line 2712: l_person_type_code igs_pe_person_types.person_type_code%TYPE := NULL;

2708: SELECT person_type_code
2709: FROM igs_pe_person_types
2710: WHERE system_type = 'FORMER_STUDENT';
2711:
2712: l_person_type_code igs_pe_person_types.person_type_code%TYPE := NULL;
2713:
2714: l_rowid VARCHAR2(25);
2715: l_pk NUMBER(15);
2716: BEGIN