DBA Data[Home] [Help]

APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_EN_INTM_TYPES

Line 5080: EXISTS( SELECT 1 FROM igs_en_intm_types

5076: AND spi.start_dt <= p_enrl_end_dt
5077: AND spi.end_dt >= p_enrl_end_dt
5078: AND spi.logical_delete_date = TO_DATE('31-12-4712','DD-MM-YYYY')
5079: AND (spi.approved = 'Y' OR
5080: EXISTS( SELECT 1 FROM igs_en_intm_types
5081: WHERE intermission_type = spi.intermission_type AND
5082: appr_reqd_ind = 'N' ));
5083:
5084: CURSOR c_spa_dt IS

Line 6446: EXISTS( SELECT 1 FROM igs_en_intm_types

6442: AND spi.logical_delete_date = TO_DATE('31-12-4712','DD-MM-YYYY')
6443: AND spi.start_dt<= cp_end_dt
6444: AND NVL(spi.end_dt,cp_end_dt) >= cp_start_dt
6445: AND (spi.approved = 'Y' OR
6446: EXISTS( SELECT 1 FROM igs_en_intm_types
6447: WHERE intermission_type = spi.intermission_type AND
6448: appr_reqd_ind = 'N' ))
6449: ORDER BY start_dt;
6450: