APPS.IGS_AD_VAL_SACCO dependencies on IGS_CA_DA

Line 14: v_s_cal_cat IGS_CA_DA.s_cal_cat%TYPE;

10: RETURN BOOLEAN AS
11: BEGIN -- admp_val_sacco_da
12: -- Validate the IGS_AD_CAL_CONF date alias values
13: DECLARE
14: v_s_cal_cat IGS_CA_DA.s_cal_cat%TYPE;
15: v_closed_ind IGS_CA_DA.closed_ind%TYPE;
16: CURSOR c_s_cal_cat IS
17: SELECT NVL(s_cal_cat, 'NULL'),
18: closed_ind

Line 15: v_closed_ind IGS_CA_DA.closed_ind%TYPE;

11: BEGIN -- admp_val_sacco_da
12: -- Validate the IGS_AD_CAL_CONF date alias values
13: DECLARE
14: v_s_cal_cat IGS_CA_DA.s_cal_cat%TYPE;
15: v_closed_ind IGS_CA_DA.closed_ind%TYPE;
16: CURSOR c_s_cal_cat IS
17: SELECT NVL(s_cal_cat, 'NULL'),
18: closed_ind
19: FROM IGS_CA_DA

Line 19: FROM IGS_CA_DA

15: v_closed_ind IGS_CA_DA.closed_ind%TYPE;
16: CURSOR c_s_cal_cat IS
17: SELECT NVL(s_cal_cat, 'NULL'),
18: closed_ind
19: FROM IGS_CA_DA
20: WHERE dt_alias = p_dt_alias;
21: BEGIN
22: p_message_name := null;
23: OPEN c_s_cal_cat;