APPS.IGS_HE_FTE_CALC_PKG dependencies on IGS_EN_INTM_TYPES

Line 898: EXISTS( SELECT 1 FROM igs_en_intm_types

894: spi.start_dt < cp_end_dt AND
895: spi.end_dt > cp_start_dt AND
896: spi.logical_delete_date = TO_DATE('31-12-4712','DD-MM-YYYY') AND
897: (spi.approved = 'Y' OR
898: EXISTS( SELECT 1 FROM igs_en_intm_types
899: WHERE intermission_type = spi.intermission_type AND
900: appr_reqd_ind = 'N' ));
901:
902: c_intm_part_rec c_intm_part%ROWTYPE ;