DBA Data[Home] [Help]

APPS.IGS_AV_GEN_001 dependencies on IGS_CA_TEACH_TO_LOAD_V

Line 2300: FROM igs_en_sua_year_v susa, igs_ca_teach_to_load_v ca

2296: AND a.s_adv_stnd_recognition_type = 'CREDIT'
2297: AND a.exemption_institution_cd(+) = ipz.oss_org_unit_cd
2298: AND (a.cal_type, a.ci_sequence_number) IN (
2299: SELECT ca.load_cal_type, ca.load_ci_sequence_number
2300: FROM igs_en_sua_year_v susa, igs_ca_teach_to_load_v ca
2301: WHERE susa.person_id = a.person_id
2302: AND susa.course_cd = a.as_course_cd
2303: AND susa.cal_type = ca.teach_cal_type
2304: AND susa.ci_sequence_number = ca.teach_ci_sequence_number