APPS.IGS_EN_NSC_PKG dependencies on IGS_CA_LOAD_TO_TEACH_V

Line 354: AND (EXISTS (SELECT 'X' FROM igs_en_su_attempt b, igs_ca_load_to_teach_v lod

350: )
351: OR
352: (cp_nslc_condition = '3'
353: AND course_attempt_status IN('ENROLLED','DISCONTIN', 'LAPSED','COMPLETED', 'INACTIVE')
354: AND (EXISTS (SELECT 'X' FROM igs_en_su_attempt b, igs_ca_load_to_teach_v lod
355: WHERE b.person_id = spa.person_id
356: and b.course_cd = spa.course_cd
357: and b.cal_type = lod.teach_cal_type
358: AND b.ci_sequence_number = lod.teach_ci_sequence_number

Line 1887: igs_en_stdnt_ps_att pr,igs_ps_ver vers,igs_ca_load_to_teach_v lt

1883: -- smaddali modified for performance bug#4914052
1884: CURSOR c_outcome_dt(p_corresp_prg VARCHAR2) IS
1885: SELECT DISTINCT asv.outcome_dt
1886: FROM igs_as_su_atmpt_itm asv, igs_en_su_attempt asav,
1887: igs_en_stdnt_ps_att pr,igs_ps_ver vers,igs_ca_load_to_teach_v lt
1888: WHERE asv.person_id = asav.person_id
1889: AND asv.course_cd = asav.course_cd
1890: AND asv.uoo_id = asav.uoo_id
1891: AND asav.person_id = pr.person_id

Line 1970: AND (EXISTS (SELECT 'X' FROM igs_en_su_attempt b, igs_ca_load_to_teach_v lod

1966: )
1967: OR
1968: (cp_nslc_condition = '3'
1969: AND course_attempt_status IN('ENROLLED','DISCONTIN', 'LAPSED','COMPLETED','INACTIVE')
1970: AND (EXISTS (SELECT 'X' FROM igs_en_su_attempt b, igs_ca_load_to_teach_v lod
1971: WHERE b.person_id = pr.person_id
1972: AND b.course_cd = pr.course_cd
1973: AND b.cal_type = lod.teach_cal_type
1974: AND b.ci_sequence_number = lod.teach_ci_sequence_number

Line 2080: igs_ca_load_to_teach_v lod

2076: CURSOR cur_spa(cp_acad_cal_type igs_ca_inst.cal_type%TYPE,cp_load_cal_type igs_ca_inst.cal_type%TYPE,
2077: cp_load_cal_seq igs_ca_inst.sequence_number%TYPE) IS
2078: SELECT DISTINCT spa.course_cd, spa.version_number
2079: FROM igs_en_su_Attempt sua,igs_en_stdnt_ps_Att spa ,
2080: igs_ca_load_to_teach_v lod
2081: WHERE spa.person_id = p_student_id
2082: AND spa.cal_type = cp_acad_cal_type
2083: AND spa.person_id = sua.person_id
2084: AND spa.course_cd = sua.course_cd

Line 2098: ( SELECT teach_cal_type,teach_ci_sequence_number FROM igs_ca_load_to_teach_v

2094: WHERE sua.person_id = p_student_id
2095: AND sua.course_cd = cp_course_cd
2096: AND sua.unit_attempt_status NOT IN ('DROPPED','DISCONTIN')
2097: AND (sua.cal_type,sua.ci_sequence_number) IN
2098: ( SELECT teach_cal_type,teach_ci_sequence_number FROM igs_ca_load_to_teach_v
2099: WHERE load_cal_type = p_load_cal_type AND load_ci_sequence_number = p_load_cal_seq
2100: );
2101: c_other_sua_rec c_other_sua%ROWTYPE;
2102:

Line 2111: ( SELECT teach_cal_type,teach_ci_sequence_number FROM igs_ca_load_to_teach_v

2107: AND course_cd = cp_course_cd
2108: AND unit_attempt_status IN ( 'DROPPED','DISCONTIN')
2109: AND sua.no_assessment_ind = 'N'
2110: AND (sua.cal_type,sua.ci_sequence_number) IN
2111: ( SELECT teach_cal_type,teach_ci_sequence_number FROM igs_ca_load_to_teach_v
2112: WHERE load_cal_type = p_load_cal_type AND load_ci_sequence_number = p_load_cal_seq )
2113: ORDER BY sua.discontinued_dt DESC ;
2114: c_disc_units_rec c_disc_units%ROWTYPE;
2115: l_inac_temp_date DATE;

Line 2684: FROM igs_ca_load_to_teach_v

2680: igs_ps_ver vers
2681: WHERE (ut.cal_type,ut.ci_sequence_number) IN
2682: (SELECT teach_cal_type,
2683: teach_ci_sequence_number
2684: FROM igs_ca_load_to_teach_v
2685: WHERE load_cal_type = p_load_cal_type
2686: AND load_ci_sequence_number = p_load_cal_seq
2687: )
2688: AND ut.person_id = p_student_id

Line 2702: FROM igs_ca_load_to_teach_v

2698: -- added by ckasu as a prt of bug 5073484.
2699: CURSOR c_get_teach_cal_dtls IS
2700: SELECT teach_cal_type,
2701: teach_ci_sequence_number
2702: FROM igs_ca_load_to_teach_v
2703: WHERE load_cal_type = p_load_cal_type
2704: AND load_ci_sequence_number = p_load_cal_seq;
2705:
2706: