APPS.IGS_AD_ACAD_HISTORY_PKG dependencies on IGS_AD_ACAD_HISTORY_V

Line 422: SELECT status,TRANSCRIPT_REQUIRED from IGS_AD_ACAD_HISTORY_V

418: l_transcript_required_old VARCHAR2(1);
419:
420: --new cursor to get old active indicator
421: CURSOR c_old_active_ind(cp_rowid IN VARCHAR2) IS
422: SELECT status,TRANSCRIPT_REQUIRED from IGS_AD_ACAD_HISTORY_V
423: WHERE row_id = cp_rowid;
424:
425: CURSOR C1 IS
426: SELECT ROWID, HZ_ACAD_HIST_ID

Line 456: FROM IGS_AD_ACAD_HISTORY_V ach

452: AND dg.program_type IS NOT NULL;
453:
454: CURSOR c_old_references IS
455: SELECT degree_attempted, degree_earned, program_code
456: FROM IGS_AD_ACAD_HISTORY_V ach
457: WHERE ach.education_id = x_education_id;
458:
459: CURSOR get_dob_dt_cur(p_person_id igs_pe_hz_parties.party_id%TYPE)
460: IS

Line 467: CURSOR cur_check_external(p_education_id igs_ad_acad_history_v.education_id%TYPE)

463: WHERE person_id = p_person_id;
464:
465: --jchin Bug 4629226 - Cursor added to check external transcripts
466:
467: CURSOR cur_check_external(p_education_id igs_ad_acad_history_v.education_id%TYPE)
468: IS
469: SELECT DISTINCT 1
470: FROM igs_ad_transcript_v trans, igs_ad_code_classes code
471: WHERE trans.transcript_source = code.code_id

Line 478: old_degree_attempted IGS_AD_ACAD_HISTORY_V.degree_attempted%TYPE;

474: AND code.class_type_code = 'ADM_CODE_CLASSES'
475: AND code.system_status = 'THIRD_PARTY_TRANSFER_EVAL';
476:
477:
478: old_degree_attempted IGS_AD_ACAD_HISTORY_V.degree_attempted%TYPE;
479: old_degree_earned IGS_AD_ACAD_HISTORY_V.degree_earned%TYPE;
480: old_program_code IGS_AD_ACAD_HISTORY_V.program_code%TYPE;
481:
482: lv_adv_standing_exists VARCHAR2(1) := NULL ;

Line 479: old_degree_earned IGS_AD_ACAD_HISTORY_V.degree_earned%TYPE;

475: AND code.system_status = 'THIRD_PARTY_TRANSFER_EVAL';
476:
477:
478: old_degree_attempted IGS_AD_ACAD_HISTORY_V.degree_attempted%TYPE;
479: old_degree_earned IGS_AD_ACAD_HISTORY_V.degree_earned%TYPE;
480: old_program_code IGS_AD_ACAD_HISTORY_V.program_code%TYPE;
481:
482: lv_adv_standing_exists VARCHAR2(1) := NULL ;
483: lv_school_attended_name hz_parties.party_name%TYPE;

Line 480: old_program_code IGS_AD_ACAD_HISTORY_V.program_code%TYPE;

476:
477:
478: old_degree_attempted IGS_AD_ACAD_HISTORY_V.degree_attempted%TYPE;
479: old_degree_earned IGS_AD_ACAD_HISTORY_V.degree_earned%TYPE;
480: old_program_code IGS_AD_ACAD_HISTORY_V.program_code%TYPE;
481:
482: lv_adv_standing_exists VARCHAR2(1) := NULL ;
483: lv_school_attended_name hz_parties.party_name%TYPE;
484: lv_school_party_id hz_education.school_party_id%TYPE ;