APPS.IGS_AS_PRC_TRANSCRPT dependencies on IGS_AV_ADV_STANDING

Line 1852: FROM IGS_AV_ADV_STANDING adv

1848: v_current_yr VARCHAR2(10);
1849: cst_trn_adv_ln CONSTANT VARCHAR2(20) := 'TRN_ADV';
1850: CURSOR c_adv IS
1851: SELECT adv.total_exmptn_granted
1852: FROM IGS_AV_ADV_STANDING adv
1853: WHERE adv.person_id = p_person_id AND
1854: adv.course_cd = p_course_cd AND
1855: adv.total_exmptn_granted > 0 AND
1856: (EXISTS (SELECT 'x'