APPS.IGS_AD_GEN_009 dependencies on IGS_AD_CNDNL_OFRSTAT

Line 13: v_adm_cndtnl_offer_status IGS_AD_CNDNL_OFRSTAT.adm_cndtnl_offer_status%TYPE;

9: -- admp_get_sys_acos
10: -- Routine to return the user-defined system default admission conditional
11: -- offer status for given the system admission conditional offer status.
12: DECLARE
13: v_adm_cndtnl_offer_status IGS_AD_CNDNL_OFRSTAT.adm_cndtnl_offer_status%TYPE;
14: CURSOR c_acos IS
15: SELECT acos.adm_cndtnl_offer_status
16: FROM IGS_AD_CNDNL_OFRSTAT acos
17: WHERE acos.s_adm_cndtnl_offer_status = p_s_adm_cndtnl_offer_status AND

Line 16: FROM IGS_AD_CNDNL_OFRSTAT acos

12: DECLARE
13: v_adm_cndtnl_offer_status IGS_AD_CNDNL_OFRSTAT.adm_cndtnl_offer_status%TYPE;
14: CURSOR c_acos IS
15: SELECT acos.adm_cndtnl_offer_status
16: FROM IGS_AD_CNDNL_OFRSTAT acos
17: WHERE acos.s_adm_cndtnl_offer_status = p_s_adm_cndtnl_offer_status AND
18: acos.system_default_ind = 'Y' AND
19: acos.closed_ind = 'N';
20: BEGIN