APPS.IGS_CA_VAL_QLITY dependencies on DUAL

Line 2460: FROM dual

2456: cp_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE,
2457: cp_acad_start_dt DATE,
2458: cp_acad_end_dt DATE ) IS
2459: SELECT 'x'
2460: FROM dual
2461: WHERE EXISTS (
2462: SELECT *
2463: FROM IGS_GE_S_GEN_CAL_CON sgcc,
2464: IGS_CA_DA_INST_V daiv

Line 2547: FROM dual

2543: cp_load_ci_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2544: cp_load_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
2545: cp_teach_ci_cal_type IGS_CA_INST.CAL_TYPE%TYPE ) IS
2546: SELECT 'x'
2547: FROM dual
2548: WHERE EXISTS (
2549: SELECT *
2550: FROM IGS_AD_ADM_UT_STT_LD
2551: WHERE ADMINISTRATIVE_UNIT_STATUS = cp_uddc_aus AND