eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_EN_ELGBL_UNIT dependencies on IGS_PS_USEC_OCCURS

Line 2498: FROM igs_ps_usec_occurs uocr,

2494: uoo.unit_cd,
2495: uoo.unit_class,
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

Line 2523: FROM igs_ps_usec_occurs uocur,

2519: uoo.unit_cd,
2520: uoo.unit_class,
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