APPS.IGS_EN_GEN_LEGACY dependencies on IGS_EN_INTM_TYPES

Line 1802: FROM igs_en_intm_types

1798: ***********************************************************************************************/
1799:
1800: CURSOR c_approv IS
1801: SELECT appr_reqd_ind
1802: FROM igs_en_intm_types
1803: WHERE intermission_type = p_intermission_type;
1804:
1805: l_appr_reqd_ind igs_en_intm_types.appr_reqd_ind%TYPE;
1806:

Line 1805: l_appr_reqd_ind igs_en_intm_types.appr_reqd_ind%TYPE;

1801: SELECT appr_reqd_ind
1802: FROM igs_en_intm_types
1803: WHERE intermission_type = p_intermission_type;
1804:
1805: l_appr_reqd_ind igs_en_intm_types.appr_reqd_ind%TYPE;
1806:
1807: BEGIN
1808: -- Cursor to check whether Approval is required for intermission or not.
1809: OPEN c_approv;

Line 1839: FROM igs_en_intm_types

1835: ***********************************************************************************************/
1836:
1837: CURSOR c_study_antr_instu IS
1838: SELECT study_antr_inst_ind
1839: FROM igs_en_intm_types
1840: WHERE intermission_type = p_intermission_type;
1841:
1842: l_study_antr_inst_ind igs_en_intm_types.study_antr_inst_ind%TYPE;
1843:

Line 1842: l_study_antr_inst_ind igs_en_intm_types.study_antr_inst_ind%TYPE;

1838: SELECT study_antr_inst_ind
1839: FROM igs_en_intm_types
1840: WHERE intermission_type = p_intermission_type;
1841:
1842: l_study_antr_inst_ind igs_en_intm_types.study_antr_inst_ind%TYPE;
1843:
1844: BEGIN
1845:
1846: -- Check whether study at another institution is set or not.