APPS.IGS_AD_GEN_001 dependencies on IGS_AD_OFR_RESP_STAT

Line 440: igs_ad_ofr_resp_stat aors,

436: FROM igs_en_stdnt_ps_att sca,
437: igs_ad_ps_appl_inst acaiv,
438: igs_ad_appl aa,
439: igs_ad_ou_stat aos,
440: igs_ad_ofr_resp_stat aors,
441: igs_ad_ofrdfrmt_stat aods
442: WHERE sca.course_attempt_status = cst_unconfirm AND
443: sca.person_id = acaiv.person_id AND
444: sca.adm_admission_appl_number = acaiv.admission_appl_number AND

Line 1061: p_s_adm_offer_resp_status IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE,

1057: --------------------------------------------------------------------------------
1058: FUNCTION admpl_chk_as(
1059: p_person_id IGS_AV_ADV_STANDING.person_id%TYPE,
1060: p_course_cd IGS_AV_ADV_STANDING.course_cd%TYPE,
1061: p_s_adm_offer_resp_status IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE,
1062: p_s_adm_offer_dfrmnt_status
1063: IGS_AD_OFRDFRMT_STAT.s_adm_offer_dfrmnt_status%TYPE)
1064: RETURN BOOLEAN
1065: IS