APPS.IGS_AD_GEN_010 dependencies on IGS_AD_OFR_RESP_STAT

Line 235: v_adm_offer_resp_status IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE;

231: v_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE;
232: v_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%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;

Line 295: igs_ad_ofr_resp_stat aors,

291: SELECT aors.s_adm_offer_resp_status,
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

Line 318: IGS_AD_OFR_RESP_STAT aors,

314: acaiv.course_cd,
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