APPS.IGS_AV_GEN_001 dependencies on IGS_AV_STND_UNIT_ALL

Line 78: FROM IGS_AV_STND_UNIT_ALL asua

74: asul.s_adv_stnd_granting_status <> cst_approved;
75:
76: CURSOR c_unit_all IS
77: SELECT rowid,av_stnd_unit_id
78: FROM IGS_AV_STND_UNIT_ALL asua
79: WHERE asua.person_id = p_person_id AND
80: asua.as_course_cd = p_course_cd ;
81:
82: CURSOR c_adv_all IS

Line 398: FROM IGS_AV_STND_UNIT_ALL

394: V_MESSAGE2 VARCHAR2(50);
395: V_MESSAGE3 VARCHAR2(50);
396: CURSOR c_adv_stnd_unit IS
397: SELECT person_id
398: FROM IGS_AV_STND_UNIT_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

Line 470: FROM igs_av_stnd_unit_all asu,

466: asu.as_course_cd course_cd,
467: asu.as_version_number version_number,
468: asu.exemption_institution_cd exemption_institution_cd,
469: uv.achievable_credit_points credit
470: FROM igs_av_stnd_unit_all asu,
471: igs_ps_unit_ver_all uv
472: WHERE asu.unit_cd = uv.unit_cd
473: AND asu.version_number = uv.version_number
474: AND asu.s_adv_stnd_recognition_type = 'CREDIT'

Line 1772: FROM IGS_AV_STND_UNIT_ALL

1768: PRAGMA EXCEPTION_INIT (e_resource_busy, -54);
1769:
1770: CURSOR c_person IS
1771: SELECT person_id
1772: FROM IGS_AV_STND_UNIT_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

Line 1927: select AV_STND_UNIT_ID from IGS_AV_STND_UNIT_ALL unt where

1923: p_person_id IN NUMBER ,
1924: p_course_cd IN VARCHAR2 ,
1925: p_version_number IN NUMBER ) IS
1926: CURSOR C_AV_UNT is
1927: select AV_STND_UNIT_ID from IGS_AV_STND_UNIT_ALL unt where
1928: person_id =p_person_id and
1929: as_course_cd = p_course_cd and
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) ;

Line 2167: p_exemption_institution_cd igs_av_stnd_unit_all.exemption_institution_cd%TYPE

2163: l_app_val NUMBER;
2164: l_grnt_val NUMBER;
2165:
2166: CURSOR c_approved (
2167: p_exemption_institution_cd igs_av_stnd_unit_all.exemption_institution_cd%TYPE
2168: )
2169: IS
2170: SELECT nvl(SUM (cp) , 0)
2171: FROM (SELECT SUM (achievable_credit_points) cp

Line 2172: FROM igs_av_stnd_unit_all unt

2168: )
2169: IS
2170: SELECT nvl(SUM (cp) , 0)
2171: FROM (SELECT SUM (achievable_credit_points) cp
2172: FROM igs_av_stnd_unit_all unt
2173: WHERE unt.exemption_institution_cd = p_exemption_institution_cd
2174: AND unt.person_id = p_person_id
2175: AND p_course_cd = unt.as_course_cd
2176: AND p_version_number = unt.as_version_number

Line 2188: p_exemption_institution_cd igs_av_stnd_unit_all.exemption_institution_cd%TYPE

2184: AND p_version_number = unt.as_version_number
2185: AND unt.s_adv_stnd_granting_status = 'APPROVED');
2186:
2187: CURSOR c_granted (
2188: p_exemption_institution_cd igs_av_stnd_unit_all.exemption_institution_cd%TYPE
2189: )
2190: IS
2191: SELECT nvl(SUM (cp),0)
2192: FROM (SELECT SUM (achievable_credit_points) cp

Line 2193: FROM igs_av_stnd_unit_all unt

2189: )
2190: IS
2191: SELECT nvl(SUM (cp),0)
2192: FROM (SELECT SUM (achievable_credit_points) cp
2193: FROM igs_av_stnd_unit_all unt
2194: WHERE unt.exemption_institution_cd = p_exemption_institution_cd
2195: AND unt.person_id = p_person_id
2196: AND p_course_cd = unt.as_course_cd
2197: AND p_version_number = unt.as_version_number

Line 2294: FROM igs_av_stnd_unit_all a, igs_pe_hz_parties ipz

2290: usverno VARCHAR2
2291: )
2292: IS
2293: SELECT SUM (a.achievable_credit_points)
2294: FROM igs_av_stnd_unit_all a, igs_pe_hz_parties ipz
2295: WHERE a.s_adv_stnd_granting_status = 'GRANTED'
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 (