APPS.IGS_CA_VAL_DAI dependencies on IGS_CA_TYPE

Line 9: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;

5: p_cal_type IN VARCHAR2 ,
6: p_message_name OUT NOCOPY VARCHAR2 )
7: RETURN BOOLEAN AS
8: v_other_detail VARCHAR2(255);
9: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
10: CURSOR c_get_holiday_cat IS
11: SELECT s_cal_cat
12: FROM IGS_CA_TYPE
13: WHERE cal_type = p_cal_type;

Line 12: FROM IGS_CA_TYPE

8: v_other_detail VARCHAR2(255);
9: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
10: CURSOR c_get_holiday_cat IS
11: SELECT s_cal_cat
12: FROM IGS_CA_TYPE
13: WHERE cal_type = p_cal_type;
14: BEGIN
15: p_message_name :=NULL;
16: OPEN c_get_holiday_cat;

Line 118: FROM IGS_CA_TYPE

114: WHERE dt_alias = p_dt_alias;
115: CURSOR c_cal_type
116: IS
117: SELECT s_cal_cat
118: FROM IGS_CA_TYPE
119: WHERE cal_type = p_cal_type;
120: v_dt_alias_closed_ind VARCHAR2(1);
121: v_dt_alias_s_cal_cat IGS_CA_DA.S_CAL_CAT%TYPE;
122: v_cal_type_s_cal_cat IGS_CA_TYPE.S_CAL_CAT%TYPE;

Line 122: v_cal_type_s_cal_cat IGS_CA_TYPE.S_CAL_CAT%TYPE;

118: FROM IGS_CA_TYPE
119: WHERE cal_type = p_cal_type;
120: v_dt_alias_closed_ind VARCHAR2(1);
121: v_dt_alias_s_cal_cat IGS_CA_DA.S_CAL_CAT%TYPE;
122: v_cal_type_s_cal_cat IGS_CA_TYPE.S_CAL_CAT%TYPE;
123: v_other_detail VARCHAR2(255);
124: BEGIN
125: OPEN c_dt_alias;
126: LOOP