APPS.IGS_AS_PRC_TRANSCRPT dependencies on IGS_AV_STND_UNIT

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 1660: l_s_adv_atnd_granting_status igs_av_stnd_unit_all.s_adv_stnd_granting_status%TYPE; --added as part of academic records maitenance DLD

1656: v_out_string VARCHAR2(500);
1657: v_dummy VARCHAR2(1);
1658: l_advgrant BOOLEAN; --added as part of academic records maitenance DLD
1659: l_credits NUMBER; --added as part of academic records maitenance DLD
1660: l_s_adv_atnd_granting_status igs_av_stnd_unit_all.s_adv_stnd_granting_status%TYPE; --added as part of academic records maitenance DLD
1661: l_message VARCHAR2(2000); --added as part of academic records maitenance DLD
1662: v_current_yr VARCHAR2(10);
1663: cst_trn_asu_ln CONSTANT VARCHAR2(20) := 'TRN_ASU';
1664: cst_trn_asu_cd CONSTANT VARCHAR2(20) := 'TRN_ASU_CD';

Line 1675: FROM IGS_AV_STND_UNIT asu,

1671: asu.unit_cd,asu.version_number,
1672: uv.short_title,
1673: uv.TITLE,
1674: uv.UNIT_LEVEL
1675: FROM IGS_AV_STND_UNIT asu,
1676: IGS_PS_UNIT_VER uv
1677: WHERE asu.person_id = p_person_id AND
1678: asu.as_course_cd = p_course_cd AND
1679: asu.s_adv_stnd_granting_status = 'GRANTED' AND

Line 1857: FROM IGS_AV_STND_UNIT asu

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'
1857: FROM IGS_AV_STND_UNIT asu
1858: WHERE asu.person_id = adv.person_id AND
1859: asu.as_course_cd = adv.course_cd AND
1860: asu.s_adv_stnd_granting_status = 'GRANTED' AND
1861: asu.s_adv_stnd_recognition_type = 'CREDIT' AND

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