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.HRI_OPL_WRKFC_EVT_MGRH dependencies on HRI_CL_WKR_SUP_STATUS_CT

Line 757: ,hri_cl_wkr_sup_status_ct stt

753: mgr.mgrs_person_fk manager_id
754: ,mnth.end_date snapshot_date
755: FROM
756: hri_cs_mngrsc_ct mgr
757: ,hri_cl_wkr_sup_status_ct stt
758: ,(SELECT
759: month.month_id
760: ,add_months(to_date(SUBSTR(to_char(month.month_id), 1, 4) || '-' ||
761: SUBSTR(to_char(month.month_id), 6, 2), 'YYYY-MM'),

Line 806: ,hri_cl_wkr_sup_status_ct stt

802: ,mnth.end_date snapshot_date
803: FROM
804: hri_eq_wrkfc_evt_mgrh eq
805: ,hri_cs_mngrsc_ct mgr
806: ,hri_cl_wkr_sup_status_ct stt
807: ,(SELECT
808: month.month_id
809: ,add_months(to_date(SUBSTR(to_char(month.month_id), 1, 4) || '-' ||
810: SUBSTR(to_char(month.month_id), 6, 2), 'YYYY-MM'),

Line 1128: ,hri_cl_wkr_sup_status_ct mgr

1124: (months_between(qtr.start_date,
1125: trunc(g_dbi_start_date,'Q')) / 3) object_id
1126: FROM
1127: hri_eq_wrkfc_evt_mgrh eq
1128: ,hri_cl_wkr_sup_status_ct mgr
1129: ,fii_time_qtr qtr
1130: WHERE eq.sup_person_id = mgr.person_id
1131: AND qtr.end_date >= eq.erlst_evnt_effective_date
1132: AND mgr.supervisor_flag = 'Y'