APPS.IGS_AS_PRC_TRANSCRPT dependencies on IGS_AV_STND_UNIT_LVL

Line 1517: FROM IGS_AV_STND_UNIT_LVL asule

1513: CURSOR c_asule IS
1514: SELECT asule.person_id,
1515: asule.UNIT_LEVEL,
1516: asule.credit_points
1517: FROM IGS_AV_STND_UNIT_LVL asule
1518: WHERE asule.person_id = p_person_id AND
1519: asule.as_course_cd = p_course_cd AND
1520: asule.s_adv_stnd_granting_status = 'GRANTED'
1521: ORDER BY

Line 1865: FROM IGS_AV_STND_UNIT_LVL asule

1861: asu.s_adv_stnd_recognition_type = 'CREDIT' AND
1862: (igs_av_val_asu.granted_adv_standing(person_id,as_course_cd,as_version_number,
1863: unit_cd,version_number,'GRANTED',NULL) ='TRUE')) OR
1864: EXISTS (SELECT 'x'
1865: FROM IGS_AV_STND_UNIT_LVL asule
1866: WHERE asule.person_id = adv.person_id AND
1867: asule.as_course_cd = adv.course_cd AND
1868: asule.s_adv_stnd_granting_status = 'GRANTED'));
1869: CURSOR c_current_yr IS