APPS.IGS_AV_VAL_ASULEB dependencies on IGS_AD_TERM_UNITDTLS

Line 300: FROM igs_ad_term_unitdtls

296: */
297: --
298: CURSOR cur_get_unit_details_id(cp_unit_details_id NUMBER, cp_unit VARCHAR2, cp_term_details_id NUMBER) IS
299: SELECT unit, term_details_id, unit_details_id, cp_attempted, cp_earned, grade, unit_grade_points
300: FROM igs_ad_term_unitdtls
301: WHERE unit_details_id = NVL(cp_unit_details_id, unit_details_id)
302: AND unit = NVL(cp_unit, unit)
303: AND term_details_id = NVL(cp_term_details_id, term_details_id);
304: rec_get_old_unit_details cur_get_unit_details_id%ROWTYPE;

Line 338: FROM igs_ad_term_unitdtls nt, igs_ad_term_details td

334: SELECT ''||(RPAD(NVL(nt.unit, nbsp), 10))||'' new_unit,
335: ''||(RPAD(NVL(td.term, nbsp), 30))||'' term_completed,
336: ''||(LPAD(NVL(TO_CHAR(nt.cp_earned), nbsp), 7))||'' cp_earned,
337: ''||(RPAD(NVL(nt.grade, nbsp),10))||'' grade
338: FROM igs_ad_term_unitdtls nt, igs_ad_term_details td
339: WHERE nt.term_details_id = cp_new_tid
340: AND td.term_details_id = nt.term_details_id
341: AND NOT EXISTS
342: (SELECT 'x'

Line 343: FROM igs_ad_term_unitdtls ot

339: WHERE nt.term_details_id = cp_new_tid
340: AND td.term_details_id = nt.term_details_id
341: AND NOT EXISTS
342: (SELECT 'x'
343: FROM igs_ad_term_unitdtls ot
344: WHERE ot.term_details_id IN (select term_details_id FROM igs_ad_term_details WHERE transcript_id = cp_old_transcript_id)
345: AND ot.unit = nt.unit);
346:
347: --Cursor to fetch the Advanced Standing details which has to be Deleted/Updated.

Line 363: igs_ad_term_unitdtls atu

359: ''||(RPAD(NVL(atu.grade, nbsp), 10))||'' new_grade,
360: 'UNIT' lvl,
361: av.av_stnd_unit_id pk
362: FROM igs_av_stnd_unit_all av,
363: igs_ad_term_unitdtls atu
364: WHERE av.person_id = cp_person_id
365: AND av.unit_details_id = cp_unit_details_id
366: AND atu.unit_details_id = av.unit_details_id
367: UNION ALL

Line 381: igs_ad_term_unitdtls atu1

377: ''||(RPAD(NVL(atu1.grade, nbsp), 10))||'' new_grade,
378: 'UNIT LEVEL' lvl,
379: avl.av_stnd_unit_lvl_id pk
380: FROM igs_av_stnd_unit_lvl_all avl,
381: igs_ad_term_unitdtls atu1
382: WHERE avl.person_id = cp_person_id
383: AND avl.unit_details_id = cp_unit_details_id
384: AND atu1.unit_details_id = avl.unit_details_id;
385: