APPS.IGS_AD_VAL_ACOS dependencies on IGS_AD_CNDNL_OFRSTAT

Line 52: v_sys_def_ind IGS_AD_CNDNL_OFRSTAT.system_default_ind%TYPE;

48: -- Check if another adm_cndtnl_offer_status record exists with the system
49: -- default indicator set to 'Y'
50: DECLARE
51: v_count_rec NUMBER;
52: v_sys_def_ind IGS_AD_CNDNL_OFRSTAT.system_default_ind%TYPE;
53: CURSOR c_count IS
54: SELECT count(*),
55: system_default_ind
56: FROM IGS_AD_CNDNL_OFRSTAT acos

Line 56: FROM IGS_AD_CNDNL_OFRSTAT acos

52: v_sys_def_ind IGS_AD_CNDNL_OFRSTAT.system_default_ind%TYPE;
53: CURSOR c_count IS
54: SELECT count(*),
55: system_default_ind
56: FROM IGS_AD_CNDNL_OFRSTAT acos
57: WHERE acos.adm_cndtnl_offer_status <> p_adm_cndtnl_offer_status AND
58: acos.s_adm_cndtnl_offer_status = p_s_adm_cndtnl_offer_status AND
59: acos.system_default_ind = 'Y'
60: GROUP BY system_default_ind;