APPS.IGS_PS_VAL_POSP dependencies on IGS_CA_INST

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 71: IGS_CA_INST ci_sub,

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
75: cir.sub_ci_sequence_number = ci_sub.sequence_number AND

Line 72: IGS_CA_INST ci_sup

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
75: cir.sub_ci_sequence_number = ci_sub.sequence_number AND
76: ci_sub.end_dt > SYSDATE 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;