APPS.IGS_AV_VAL_ASULEB dependencies on IGS_AD_TERM_DETAILS

Line 310: FROM igs_ad_term_details

306:
307: --Cursor to fetch all terms attached to the Transcript.
308: CURSOR cur_get_term_dtls(cp_transcript_id NUMBER, cp_term_details_id NUMBER)IS
309: SELECT term_details_id, transcript_id
310: FROM igs_ad_term_details
311: WHERE transcript_id = NVL(cp_transcript_id, transcript_id) AND
312: term_details_id = NVL(cp_term_details_id, term_details_id);
313: rec_get_old_term_dtls cur_get_term_dtls%ROWTYPE;
314:

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 344: WHERE ot.term_details_id IN (select term_details_id FROM igs_ad_term_details WHERE transcript_id = cp_old_transcript_id)

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.
348: CURSOR cur_del_adv_dtls (cp_person_id NUMBER,

Line 407: FROM igs_ad_term_details td

403:
404: --Cursor to fetch the New Term Name
405: CURSOR cur_get_term(cp_term_details_id NUMBER) IS
406: SELECT ''||(RPAD(NVL(td.term, nbsp), 30))||'' term_completed
407: FROM igs_ad_term_details td
408: WHERE td.term_details_id = cp_term_details_id;
409: rec_get_term cur_get_term%ROWTYPE;
410: rec_get_new_term cur_get_term%ROWTYPE;
411: