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.

APPS.HR_WRK_SCH_PKG dependencies on CAC_SR_SCHDL_OBJECTS

Line 74: FROM cac_sr_schdl_objects CSSO

70: ,cp_end_date IN DATE
71: ,cp_sch_cat IN VARCHAR2
72: ) IS
73: SELECT COUNT(*)
74: FROM cac_sr_schdl_objects CSSO
75: ,cac_sr_schedules_b CSSB
76: WHERE CSSO.object_type = cp_object_type
77: AND CSSO.object_id = cp_object_id
78: AND CSSO.start_date_active <= cp_end_date

Line 99: FROM cac_sr_schdl_objects CSSO

95: ,cp_end_date IN DATE
96: ,cp_sch_cat IN VARCHAR2
97: ) IS
98: SELECT CSSO.start_date_active,CSSO.end_date_active
99: FROM cac_sr_schdl_objects CSSO
100: ,cac_sr_schedules_b CSSB
101: WHERE CSSO.object_type = cp_object_type
102: AND CSSO.object_id = cp_object_id
103: AND CSSO.start_date_active <= cp_end_date

Line 506: FROM cac_sr_schdl_objects CSSO

502: ,cp_end_date IN DATE
503: ,cp_sch_cat IN VARCHAR2
504: ) IS
505: SELECT COUNT(*)
506: FROM cac_sr_schdl_objects CSSO
507: ,cac_sr_schedules_b CSSB
508: WHERE CSSO.object_type = cp_object_type
509: AND CSSO.object_id = cp_object_id
510: AND CSSO.start_date_active <= cp_end_date

Line 533: FROM cac_sr_schdl_objects CSSO

529: ,cp_end_date IN DATE
530: ,cp_sch_cat IN VARCHAR2
531: ) IS
532: SELECT CSSO.start_date_active,CSSO.end_date_active
533: FROM cac_sr_schdl_objects CSSO
534: ,cac_sr_schedules_b CSSB
535: WHERE CSSO.object_type = cp_object_type
536: AND CSSO.object_id = cp_object_id
537: AND CSSO.start_date_active <= cp_end_date