APPS.IGS_PS_VAL_POSP dependencies on IGS_CA_INST_REL

Line 70: FROM IGS_CA_INST_REL cir,

66: DECLARE
67: v_dummy VARCHAR(1);
68: CURSOR c_cir_ci IS
69: SELECT 'X'
70: FROM IGS_CA_INST_REL cir,
71: IGS_CA_INST ci_sub,
72: IGS_CA_INST ci_sup
73: WHERE cir.sub_cal_type = p_teach_cal_type AND
74: cir.sub_cal_type = ci_sub.cal_type AND

Line 87: -- Check for IGS_CA_INST_REL records where the p_teach_cal_type

83: p_teach_cal_type IS NULL THEN
84: p_message_name := NULL;
85: RETURN TRUE;
86: ELSE
87: -- Check for IGS_CA_INST_REL records where the p_teach_cal_type
88: -- is the sub_cal_type and the p_cal_type is the sup_cal_type and the
89: -- related calendar_instance records have an end date greater than todays
90: -- date
91: OPEN c_cir_ci;