DBA Data[Home] [Help]

APPS.IGS_AS_SS_DOC_REQUEST dependencies on IGS_CA_TEACH_TO_LOAD_V

Line 1194: igs_ca_teach_to_load_v

1190: ) RETURN VARCHAR2 AS
1191: CURSOR c_sua_cmnt IS
1192: SELECT load_description
1193: FROM igs_en_su_attempt,
1194: igs_ca_teach_to_load_v
1195: WHERE person_id = p_person_id
1196: AND course_cd = p_course_cd
1197: AND unit_attempt_status IN ('ENROLLED', 'COMPLETED', 'DUPLICATE', 'DISCONTIN')
1198: AND teach_cal_type = cal_type

Line 1205: igs_ca_teach_to_load_v

1201: --
1202: CURSOR c_sua_end IS
1203: SELECT load_description
1204: FROM igs_en_su_attempt,
1205: igs_ca_teach_to_load_v
1206: WHERE person_id = p_person_id
1207: AND course_cd = p_course_cd
1208: AND unit_attempt_status IN ('ENROLLED', 'COMPLETED', 'DUPLICATE', 'DISCONTIN')
1209: AND teach_cal_type = cal_type