APPS.IGS_AD_GEN_010 dependencies on IGS_AD_OFRDFRMT_STAT

Line 237: IGS_AD_OFRDFRMT_STAT.s_adm_offer_dfrmnt_status%TYPE;

233: v_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE;
234: v_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE;
235: v_adm_offer_resp_status IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE;
236: v_adm_offer_dfrmnt_status
237: IGS_AD_OFRDFRMT_STAT.s_adm_offer_dfrmnt_status%TYPE;
238: v_enrol_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
239: v_tac_match BOOLEAN;
240: v_course_off_found BOOLEAN;
241: v_course_ins_found BOOLEAN;

Line 296: igs_ad_ofrdfrmt_stat aods

292: aods.s_adm_offer_dfrmnt_status
293: FROM igs_ad_appl aa,
294: igs_ad_ps_appl_inst acaiv, /* Replaced IGS_AD_PS_APPL_INST_APLINST_V with IGS_AD_PS_APPL_INST. Bug 3150054 */
295: igs_ad_ofr_resp_stat aors,
296: igs_ad_ofrdfrmt_stat aods
297: WHERE acaiv.person_id = cp_matched_id AND
298: aa.acad_cal_type = p_acad_cal_type AND
299: aa.acad_ci_sequence_number = p_acad_ci_sequence_number AND
300: acaiv.course_cd = cp_course_cd AND

Line 319: IGS_AD_OFRDFRMT_STAT aods,

315: ceprc.reference_cd
316: FROM igs_ad_appl aa,
317: IGS_AD_PS_APPL_INST acaiv, /* Replaced IGS_AD_PS_APPL_INST_APLINST_V with IGS_AD_PS_APPL_INST. Bug 3150054 */
318: IGS_AD_OFR_RESP_STAT aors,
319: IGS_AD_OFRDFRMT_STAT aods,
320: IGS_PS_ENT_PT_REF_CD ceprc,
321: IGS_GE_REF_CD_TYPE rct
322: WHERE acaiv.person_id = cp_matched_id AND
323: aa.acad_cal_type = p_acad_cal_type AND