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_ORGH dependencies on FII_TIME_MONTH

Line 746: ,fii_time_month mnth

742: SUBSTR(to_char(mnth.month_id), 6, 2), 'YYYY-MM'),
743: 1) - 1 snapshot_date
744: FROM
745: hri_cs_orgh_ct orgh
746: ,fii_time_month mnth
747: WHERE orgh.orgh_relative_level = 0
748: AND mnth.month_id >= to_number(to_char(g_dbi_start_date, 'YYYYQMM'))
749: AND mnth.month_id <= to_number(to_char(g_sysdate, 'YYYYQMM'))
750: AND orgh.orgh_sub_node_has_workers_flag = 'Y'

Line 787: ,fii_time_month mnth

783: 1) - 1 snapshot_date
784: FROM
785: hri_eq_wrkfc_evt_orgh eq
786: ,hri_cs_orgh_ct orgh
787: ,fii_time_month mnth
788: WHERE mnth.month_id >= to_number(to_char(eq.erlst_evnt_effective_date, 'YYYYQMM'))
789: AND mnth.month_id >= to_number(to_char(g_dbi_start_date, 'YYYYQMM'))
790: AND mnth.month_id <= to_number(to_char(g_sysdate, 'YYYYQMM'))
791: AND eq.organization_id BETWEEN p_start_object_id