APPS.IGS_DA_TRNS_IMP dependencies on IGS_AD_CODE_CLASSES

Line 436: FROM igs_ad_code_classes

432: SELECT trans_oss.ROWID, trans_oss.*
433: FROM igs_ad_transcript trans_oss
434: WHERE transcript_source IN (
435: SELECT code_id
436: FROM igs_ad_code_classes
437: WHERE CLASS = 'TRANSCRIPT_SOURCE'
438: AND closed_ind = 'N'
439: AND system_status = 'THIRD_PARTY_TRANSFER_EVAL')
440: AND education_id = cp_education_id

Line 572: FROM igs_ad_code_classes

568:
569: CURSOR c_source
570: IS
571: SELECT code_id
572: FROM igs_ad_code_classes
573: WHERE CLASS = 'TRANSCRIPT_SOURCE'
574: AND closed_ind = 'N'
575: AND system_status = 'THIRD_PARTY_TRANSFER_EVAL'
576: ORDER BY NVL (system_default, 'A') DESC;

Line 578: l_transcript_source igs_ad_code_classes.code_id%TYPE;

574: AND closed_ind = 'N'
575: AND system_status = 'THIRD_PARTY_TRANSFER_EVAL'
576: ORDER BY NVL (system_default, 'A') DESC;
577:
578: l_transcript_source igs_ad_code_classes.code_id%TYPE;
579: BEGIN
580: ecx_debug.push ('IGS_DA_TRNS_IMP.CREATE_NEW_TRANSCRIPT_DETAILS');
581: l_transcript_id := NULL;
582:

Line 712: FROM igs_ad_code_classes

708:
709: CURSOR c_source
710: IS
711: SELECT code_id
712: FROM igs_ad_code_classes
713: WHERE CLASS = 'TRANSCRIPT_SOURCE'
714: AND closed_ind = 'N'
715: AND system_status = 'THIRD_PARTY_TRANSFER_EVAL';
716:

Line 718: l_source igs_ad_code_classes.code_id%TYPE;

714: AND closed_ind = 'N'
715: AND system_status = 'THIRD_PARTY_TRANSFER_EVAL';
716:
717: dup_cur_rec c_dup_cur%ROWTYPE;
718: l_source igs_ad_code_classes.code_id%TYPE;
719: BEGIN
720: ecx_debug.push ('IGS_DA_TRNS_IMP.UPDATE_TRANSCRIPT_DETAILS');
721: l_transcript_id := NULL;
722: OPEN c_dup_cur;

Line 914: FROM igs_ad_code_classes

910: AS
911: CURSOR c_unit_difficulty
912: IS
913: SELECT code_id
914: FROM igs_ad_code_classes
915: WHERE CLASS = 'UNIT_DIFFICULTY' AND NAME = 'STANDARD';
916:
917: l_rowid VARCHAR2 (25);
918: l_var VARCHAR2 (25);

Line 1397: FROM igs_ad_code_classes

1393: WHERE education_id = l_trans_cur_rec.education_id
1394: AND transcript_status = 'FINAL'
1395: AND transcript_source IN (
1396: SELECT code_id
1397: FROM igs_ad_code_classes
1398: WHERE CLASS = 'TRANSCRIPT_SOURCE'
1399: AND closed_ind = 'N'
1400: AND system_status = 'THIRD_PARTY_TRANSFER_EVAL')
1401: AND entered_gs_id = fnd_profile.VALUE ('IGS_AD_INST_GRAD_SCALE')