APPS.IGS_AD_GEN_009 dependencies on IGS_AD_OFR_RESP_STAT

Line 187: v_adm_offer_resp_status IGS_AD_OFR_RESP_STAT.adm_offer_resp_status%TYPE;

183: -- admp_get_sys_aors
184: -- Routine to return the user-defined system default admission offer
185: -- response status for given the system admission offer response status.
186: DECLARE
187: v_adm_offer_resp_status IGS_AD_OFR_RESP_STAT.adm_offer_resp_status%TYPE;
188: CURSOR c_aors IS
189: SELECT aors.adm_offer_resp_status
190: FROM IGS_AD_OFR_RESP_STAT aors
191: WHERE aors.s_adm_offer_resp_status = p_s_adm_offer_resp_status AND

Line 190: FROM IGS_AD_OFR_RESP_STAT aors

186: DECLARE
187: v_adm_offer_resp_status IGS_AD_OFR_RESP_STAT.adm_offer_resp_status%TYPE;
188: CURSOR c_aors IS
189: SELECT aors.adm_offer_resp_status
190: FROM IGS_AD_OFR_RESP_STAT aors
191: WHERE aors.s_adm_offer_resp_status = p_s_adm_offer_resp_status AND
192: aors.system_default_ind = 'Y' AND
193: aors.closed_ind = 'N';
194: BEGIN