APPS.IGS_EN_VAL_UDDC dependencies on IGS_CA_DA

Line 88: v_closed_ind IGS_CA_DA.closed_ind%TYPE;

84: RETURN BOOLEAN AS
85: BEGIN
86: DECLARE
87:
88: v_closed_ind IGS_CA_DA.closed_ind%TYPE;
89: v_s_cal_cat IGS_CA_DA.s_cal_cat%TYPE;
90: CURSOR c_dt_alias IS
91: SELECT s_cal_cat,
92: closed_ind

Line 89: v_s_cal_cat IGS_CA_DA.s_cal_cat%TYPE;

85: BEGIN
86: DECLARE
87:
88: v_closed_ind IGS_CA_DA.closed_ind%TYPE;
89: v_s_cal_cat IGS_CA_DA.s_cal_cat%TYPE;
90: CURSOR c_dt_alias IS
91: SELECT s_cal_cat,
92: closed_ind
93: FROM IGS_CA_DA

Line 93: FROM IGS_CA_DA

89: v_s_cal_cat IGS_CA_DA.s_cal_cat%TYPE;
90: CURSOR c_dt_alias IS
91: SELECT s_cal_cat,
92: closed_ind
93: FROM IGS_CA_DA
94: WHERE dt_alias = p_dt_alias;
95: BEGIN
96: -- This module checks if the IGS_CA_DA is closed
97: -- and if the SI_CA_S_CA_CAT is specified, then it must

Line 96: -- This module checks if the IGS_CA_DA is closed

92: closed_ind
93: FROM IGS_CA_DA
94: WHERE dt_alias = p_dt_alias;
95: BEGIN
96: -- This module checks if the IGS_CA_DA is closed
97: -- and if the SI_CA_S_CA_CAT is specified, then it must
98: -- be 'TEACHING'
99: p_message_name := null;
100: OPEN c_dt_alias;