DBA Data[Home] [Help]

APPS.IGS_EN_VAL_ENCMB dependencies on IGS_CA_INST

Line 1894: CURSOR sup_cal(cp_cal_Type igs_ca_inst.cal_type%TYPE, cp_cal_seq igs_ca_inst.sequence_number%TYPE) IS

1890:
1891:
1892:
1893: -- Getting the academic calender for the load calender.
1894: CURSOR sup_cal(cp_cal_Type igs_ca_inst.cal_type%TYPE, cp_cal_seq igs_ca_inst.sequence_number%TYPE) IS
1895: SELECT SUP_CAL_TYPE, SUP_CI_SEQUENCE_NUMBER
1896: FROM igs_ca_inst_rel
1897: WHERE sub_cal_type = cp_cal_Type
1898: AND sub_ci_sequence_number = cp_cal_seq

Line 1896: FROM igs_ca_inst_rel

1892:
1893: -- Getting the academic calender for the load calender.
1894: CURSOR sup_cal(cp_cal_Type igs_ca_inst.cal_type%TYPE, cp_cal_seq igs_ca_inst.sequence_number%TYPE) IS
1895: SELECT SUP_CAL_TYPE, SUP_CI_SEQUENCE_NUMBER
1896: FROM igs_ca_inst_rel
1897: WHERE sub_cal_type = cp_cal_Type
1898: AND sub_ci_sequence_number = cp_cal_seq
1899: AND sup_cal_type
1900: IN (SELECT CAL_TYPE FROM IGS_CA_TYPE WHERE S_CAL_CAT = 'ACADEMIC');