APPS.IGS_SS_EN_WRAPPERS dependencies on IGS_CA_LOAD_TO_TEACH_V

Line 815: AND 0< (SELECT 1 FROM igs_ca_load_to_teach_v vt

811: AND sua.uoo_id = uoo.uoo_id
812: AND enusecstat.unit_section_status = uoo.unit_section_status
813: AND enusecstat.displayed = 'Y'
814: AND sua.unit_attempt_status IN ( 'UNCONFIRM','INVALID' )
815: AND 0< (SELECT 1 FROM igs_ca_load_to_teach_v vt
816: WHERE vt.load_cal_type =cp_load_cal_type
817: AND vt.load_ci_sequence_number=cp_load_ci_seq_num
818: AND sua.cal_type = vt.teach_cal_type
819: AND sua.ci_sequence_number = vt.teach_ci_sequence_number) ;

Line 838: 0< (SELECT 1 FROM igs_ca_load_to_teach_v vt

834: enusecstat.unit_section_status = uoo.unit_section_status AND
835: enusecstat.displayed = 'Y' AND
836: sua.unit_attempt_status IN ('UNCONFIRM','INVALID') AND
837: sua.no_assessment_ind = 'N' AND
838: 0< (SELECT 1 FROM igs_ca_load_to_teach_v vt
839: WHERE vt.load_cal_type=cp_load_cal_type
840: AND vt.load_ci_sequence_number=cp_load_ci_seq_num
841: AND sua.cal_type=vt.teach_cal_type
842: AND sua.ci_sequence_number=vt.teach_ci_sequence_number)

Line 1235: FROM IGS_EN_SU_ATTEMPT U, IGS_CA_LOAD_TO_TEACH_V

1231: l_drop_uoo_ids := p_uoo_ids;
1232:
1233: OPEN c_ref_cur_inst FOR '
1234: SELECT DISTINCT u.person_id
1235: FROM IGS_EN_SU_ATTEMPT U, IGS_CA_LOAD_TO_TEACH_V
1236: WHERE person_id =:1
1237: AND course_cd = :2
1238: AND unit_attempt_status IN (''ENROLLED'',''INVALID'',''WAITLISTED'')
1239: AND cal_type = teach_cal_type

Line 1263: FROM igs_ca_load_to_teach_v

1259: WHERE person_id =:1 AND
1260: unit_attempt_status <> ''DUPLICATE'' AND
1261: (cal_type,ci_sequence_number) IN
1262: (SELECT teach_cal_type,teach_ci_sequence_number
1263: FROM igs_ca_load_to_teach_v
1264: WHERE load_cal_type = :2
1265: AND load_ci_sequence_number =:3 )
1266: AND uoo_id IN('||l_drop_uoo_ids||')'
1267: USING p_person_id, p_load_cal_type, p_load_sequence_number;

Line 2882: OPEN c_ref_cur_inst FOR 'SELECT DISTINCT U.PERSON_ID FROM IGS_EN_SU_ATTEMPT U, igs_ca_load_to_teach_v WHERE person_id =:1 AND course_cd = :2 '||

2878: END IF;
2879: --Decode the concatenated string and check that all units are not selected,
2880: --in which case, just delete all units w/o checking cp or coreq requirements.
2881:
2882: OPEN c_ref_cur_inst FOR 'SELECT DISTINCT U.PERSON_ID FROM IGS_EN_SU_ATTEMPT U, igs_ca_load_to_teach_v WHERE person_id =:1 AND course_cd = :2 '||
2883: 'AND unit_attempt_status IN (''ENROLLED'',''INVALID'',''WAITLISTED'') '||
2884: 'AND cal_type = teach_cal_type AND ci_sequence_number= teach_ci_sequence_number '||
2885: 'AND load_cal_type = :3 AND load_ci_sequence_number =:4 '||
2886: 'AND uoo_id <> :5 '