APPS.IGS_AD_DEF_APPL_PKG dependencies on IGS_AD_OFRDFRMT_STAT_V

Line 357: igs_ad_ofrdfrmt_stat_v aods

353: p_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
354: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE) IS
355: SELECT aods.s_adm_offer_dfrmnt_status
356: FROM igs_ad_ps_appl_inst apai,
357: igs_ad_ofrdfrmt_stat_v aods
358: WHERE apai.person_id =p_person_id
359: AND apai.admission_appl_number =p_admission_appl_number
360: AND apai.nominated_course_cd =p_nominated_course_cd
361: AND apai.sequence_number =p_sequence_number

Line 367: l_s_adm_offer_dfrmnt_status igs_ad_ofrdfrmt_stat_v.s_adm_offer_dfrmnt_status%TYPE;

363:
364: l_message_name VARCHAR2(1000);
365: l_new_admission_appl_number igs_ad_appl.admission_appl_number%TYPE;
366: l_new_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE;
367: l_s_adm_offer_dfrmnt_status igs_ad_ofrdfrmt_stat_v.s_adm_offer_dfrmnt_status%TYPE;
368:
369: v_start_dt DATE;
370:
371: CURSOR c_get_acad_cal_info(cp_person_id igs_ad_appl_all.person_id%TYPE,