APPS.IGS_AV_GEN_001 dependencies on IGS_EN_SUA_YEAR_V

Line 2280: FROM igs_en_sua_year_v he

2276: NULL,
2277: NULL
2278: )
2279: )
2280: FROM igs_en_sua_year_v he
2281: WHERE he.person_id = personid
2282: AND he.course_cd = coursecd
2283: AND he.unit_set_cd = unitsetcd
2284: AND he.us_version_number = usverno;

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