APPS.IGS_EN_TIMESLOTS dependencies on IGS_EN_STDNT_PS_ATT

Line 259: FROM igs_en_stdnt_ps_att sca,

255: l_seq_num igs_en_timeslot_stup.sequence_number%TYPE;
256:
257: CURSOR cur_prog_type(p_person_id NUMBER , p_course_type VARCHAR2 ) IS
258: SELECT sca.person_id
259: FROM igs_en_stdnt_ps_att sca,
260: igs_ps_ver pv
261: WHERE sca.person_id = p_person_id AND
262: sca.course_cd = pv.course_cd AND
263: sca.version_number = pv.version_number AND

Line 268: FROM igs_en_stdnt_ps_att sca,

264: pv.course_type = p_course_type;
265:
266: CURSOR cur_org_unit (p_person_id NUMBER , p_org_unit_cd VARCHAR2 ) IS
267: SELECT sca.person_id
268: FROM igs_en_stdnt_ps_att sca,
269: igs_ps_ver pv
270: WHERE sca.person_id = p_person_id AND
271: sca.course_cd = pv.course_cd AND
272: sca.version_number = pv.version_number AND

Line 277: FROM igs_en_stdnt_ps_att sca

273: pv.responsible_org_unit_cd = p_org_unit_cd;
274:
275: CURSOR cur_program (p_person_id NUMBER , p_course_cd VARCHAR2,p_version_number NUMBER ) IS
276: SELECT sca.person_id
277: FROM igs_en_stdnt_ps_att sca
278: WHERE sca.person_id = p_person_id AND
279: sca.course_cd = p_course_cd AND
280: sca.version_number = p_version_number;
281:

Line 294: FROM igs_en_stdnt_ps_att sca,

290: AND nvl( pgm.END_DATE,SYSDATE)>= SYSDATE;
291:
292: CURSOR cur_prog_stage (p_person_id NUMBER , p_course_stage_type VARCHAR2 ) IS
293: SELECT sca.person_id
294: FROM igs_en_stdnt_ps_att sca,
295: igs_ps_stage ps
296: WHERE sca.person_id = p_person_id AND
297: sca.course_cd = ps.course_cd AND
298: sca.version_number = ps.version_number AND

Line 303: FROM igs_en_stdnt_ps_att sca

299: ps.course_stage_type = p_course_stage_type;
300:
301: CURSOR cur_prog_cd (p_person_id NUMBER) IS
302: SELECT sca.course_cd
303: FROM igs_en_stdnt_ps_att sca
304: WHERE sca.person_id = p_person_id and
305: sca.course_attempt_status = 'ENROLLED';
306:
307: CURSOR cur_load_teach_prd (p_person_id NUMBER,

Line 335: cur_criteria_rec igs_en_stdnt_ps_att.person_id%TYPE;

331: uoo.uoo_id = cp_uoo_id;
332:
333: cur_enrolled_cp_rec cur_enrolled_cp%ROWTYPE;
334: cur_load_teach_prd_rec cur_load_teach_prd%ROWTYPE;
335: cur_criteria_rec igs_en_stdnt_ps_att.person_id%TYPE;
336: cnt_2 NUMBER := 0;
337: cnt_tmp NUMBER := 0;
338: plsql_2 plsql_table_1;
339: plsql_tmp plsql_table_1;

Line 382: FROM IGS_EN_STDNT_PS_ATT sca

378: l_load_ci_sequence_number igs_ca_teach_to_load_v.load_ci_sequence_number%TYPE;
379:
380: CURSOR c_ps_att IS
381: SELECT course_cd, version_number, cal_type
382: FROM IGS_EN_STDNT_PS_ATT sca
383: WHERE person_id = p_person_id;
384: l_ps_att c_ps_att%ROWTYPE;
385:
386: l_gpa NUMBER;

Line 1918: FROM igs_en_stdnt_ps_att sca,

1914: -- be before the start date of the calendar instance provided.
1915: -- smaddali modified for bug#3918075, to move intermissions join to a subquery
1916: CURSOR cur_total_enrled_stdnts(p_start_dt DATE ) IS
1917: SELECT DISTINCT (pe.person_id) person_id ,pe.last_name
1918: FROM igs_en_stdnt_ps_att sca,
1919: igs_pe_person_base_v pe,
1920: igs_ps_ver pv,
1921: igs_ps_type pt
1922: WHERE pe.person_id = sca.person_id AND

Line 1956: FROM IGS_EN_STDNT_PS_ATT_ALL sca,

1952: -- having any unit attempts.
1953: CURSOR cur_total_admted_stdnts(cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE, cp_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
1954:
1955: SELECT sca.person_id person_id ,(select person_last_name from hz_parties where party_id = sca.person_id) last_name
1956: FROM IGS_EN_STDNT_PS_ATT_ALL sca,
1957: igs_ps_ver_all pv,
1958: igs_ps_type_all pt,
1959: IGS_AD_PS_APPL_INST_all acai,
1960: IGS_AD_APPL_all aav,

Line 1990: IGS_EN_STDNT_PS_ATT_ALL sca2

1986: UNION
1987: SELECT sca2.person_id person_id ,(select person_last_name from hz_parties where party_id = sca2.person_id) last_name
1988: FROM igs_ps_ver_all pv2,
1989: igs_ps_type_all pt2,
1990: IGS_EN_STDNT_PS_ATT_ALL sca2
1991: WHERE pt2.course_type_group_cd = p_prg_type_gr_cd AND
1992: pv2.course_type = pt2.course_type AND
1993: pv2.course_cd = sca2.course_cd AND
1994: pv2.version_number = sca2.version_number AND