APPS.IGS_AV_GEN_001 dependencies on IGS_AV_STND_UNIT_LVL_ALL

Line 90: FROM IGS_AV_STND_UNIT_LVL_ALL aslvl

86: asal.course_cd = p_course_cd;
87:
88: CURSOR c_unit_lvl_all IS
89: SELECT rowid,av_stnd_unit_lvl_id
90: FROM IGS_AV_STND_UNIT_LVL_ALL aslvl
91: WHERE aslvl.person_id = p_person_id AND
92: aslvl.as_course_cd = p_course_cd;
93:
94: CURSOR c_unit_basis_all(cp_unit_id IGS_AV_STD_UNT_BASIS_ALL.av_stnd_unit_id%TYPE) IS

Line 403: FROM IGS_AV_STND_UNIT_LVL_ALL

399: WHERE s_adv_stnd_granting_status = cst_approved AND
400: s_adv_stnd_recognition_type = cst_credit
401: UNION
402: SELECT person_id
403: FROM IGS_AV_STND_UNIT_LVL_ALL
404: WHERE s_adv_stnd_granting_status = cst_approved;
405: BEGIN
406: FOR v_adv_stnd_unit IN c_adv_stnd_unit LOOP
407: IF NOT advp_upd_as_pe_grant(

Line 482: FROM igs_av_stnd_unit_lvl_all asule

478: asule.as_course_cd,
479: asule.as_version_number,
480: asule.exemption_institution_cd,
481: asule.credit_points credit
482: FROM igs_av_stnd_unit_lvl_all asule
483: WHERE asule.s_adv_stnd_granting_status = 'GRANTED') suc
484: WHERE suc.person_id = p_person_id
485: AND suc.course_cd = p_course_cd
486: AND suc.version_number = p_version_number

Line 1777: FROM IGS_AV_STND_UNIT_LVL_ALL

1773: WHERE s_adv_stnd_granting_status = 'APPROVED' AND
1774: NVL(expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) < SYSDATE
1775: UNION
1776: SELECT person_id
1777: FROM IGS_AV_STND_UNIT_LVL_ALL
1778: WHERE s_adv_stnd_granting_status = 'APPROVED' AND
1779: NVL(expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) < SYSDATE;
1780:
1781: CURSOR c_adv_stnd_unit (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS

Line 1934: select AV_STND_UNIT_LVL_ID from IGS_AV_STND_UNIT_LVL_ALL ulvl where

1930: as_version_number = p_version_number and
1931: not exists ( select 1 from IGS_AV_STD_UNT_BASIS_ALL basis where basis.AV_STND_UNIT_ID= unt.AV_STND_UNIT_ID) ;
1932:
1933: CURSOR C_AV_UNT_LVL is
1934: select AV_STND_UNIT_LVL_ID from IGS_AV_STND_UNIT_LVL_ALL ulvl where
1935: person_id =p_person_id and
1936: as_course_cd = p_course_cd and
1937: as_version_number = p_version_number and
1938: not exists ( select 1 from IGS_AV_STD_ULVLBASIS_ALL basis where basis.AV_STND_UNIT_LVL_ID= ulvl.AV_STND_UNIT_LVL_ID) ;

Line 2180: FROM igs_av_stnd_unit_lvl_all unt

2176: AND p_version_number = unt.as_version_number
2177: AND unt.s_adv_stnd_granting_status = 'APPROVED'
2178: UNION ALL
2179: SELECT SUM (credit_points) cp
2180: FROM igs_av_stnd_unit_lvl_all unt
2181: WHERE unt.exemption_institution_cd = p_exemption_institution_cd
2182: AND unt.person_id = p_person_id
2183: AND p_course_cd = unt.as_course_cd
2184: AND p_version_number = unt.as_version_number

Line 2201: FROM igs_av_stnd_unit_lvl_all unt

2197: AND p_version_number = unt.as_version_number
2198: AND unt.s_adv_stnd_granting_status = 'GRANTED'
2199: UNION ALL
2200: SELECT SUM (credit_points) cp
2201: FROM igs_av_stnd_unit_lvl_all unt
2202: WHERE unt.exemption_institution_cd = p_exemption_institution_cd
2203: AND unt.person_id = p_person_id
2204: AND p_course_cd = unt.as_course_cd
2205: AND p_version_number = unt.as_version_number

Line 2312: FROM igs_av_stnd_unit_lvl_all a, igs_pe_hz_parties ipz

2308:
2309: CURSOR c_credit_pts_3 (personid NUMBER, coursecd VARCHAR2)
2310: IS
2311: SELECT SUM (a.credit_points)
2312: FROM igs_av_stnd_unit_lvl_all a, igs_pe_hz_parties ipz
2313: WHERE a.s_adv_stnd_granting_status = 'GRANTED'
2314: AND a.exemption_institution_cd(+) = ipz.oss_org_unit_cd
2315: AND (personid = person_id)
2316: AND (coursecd = as_course_cd);