DBA Data[Home] [Help]

APPS.IGS_EN_ELGBL_UNIT dependencies on IGS_CA_INST

Line 2500: igs_ca_inst ci

2496: NVL (uocr.start_date, NVL (uoo.unit_section_start_date, ci.start_dt)) start_date,
2497: NVL (uocr.end_date, NVL (uoo.unit_section_end_date, ci.end_dt)) end_date
2498: FROM igs_ps_usec_occurs uocr,
2499: igs_ps_unit_ofr_opt uoo,
2500: igs_ca_inst ci
2501: WHERE uoo.uoo_id = cp_uoo_id
2502: AND uoo.uoo_id = uocr.uoo_id
2503: AND uoo.cal_type = ci.cal_type
2504: AND uoo.ci_sequence_number = ci.sequence_number;

Line 2525: igs_ca_inst lt,

2521: NVL (uocur.start_date, NVL (uoo.unit_section_start_date, lt.start_dt)) start_date,
2522: NVL (uocur.end_date, NVL (uoo.unit_section_end_date, lt.end_dt)) end_date
2523: FROM igs_ps_usec_occurs uocur,
2524: igs_en_su_attempt_all ua,
2525: igs_ca_inst lt,
2526: igs_ps_unit_ofr_opt_all uoo
2527: WHERE uocur.uoo_id = ua.uoo_id
2528: AND uoo.uoo_id = ua.uoo_id
2529: AND ua.uoo_id <> p_uoo_id