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_OLTP_VIEW_WRKFRC dependencies on HRI_MDS_WRKFC_MNTH_CT

Line 74: FROM hri_mds_wrkfc_mnth_ct fct

70: ,fct.job_job_fk
71: ,fct.grd_grade_fk
72: ,fct.pos_position_fk
73: ,fct.geo_location_fk
74: FROM hri_mds_wrkfc_mnth_ct fct
75: WHERE fct.asg_assgnmnt_fk = p_assignment_id
76: AND fct.time_month_snp_fk = to_number(to_char(p_effective_date, 'YYYYQMM'));
77:
78: BEGIN

Line 222: FROM hri_mds_wrkfc_mnth_ct

218: CURSOR hire_csr IS
219: SELECT
220: NVL(SUM(headcount_hire), 0)
221: ,NVL(SUM(fte_hire), 0)
222: FROM hri_mds_wrkfc_mnth_ct
223: WHERE asg_assgnmnt_fk = p_assignment_id
224: AND time_month_snp_fk BETWEEN to_number(to_char(p_effective_start_date, 'YYYYQMM'))
225: AND to_number(to_char(p_effective_end_date, 'YYYYQMM'));
226:

Line 256: FROM hri_mds_wrkfc_mnth_ct

252: CURSOR prmtn_csr IS
253: SELECT
254: NVL(SUM(headcount_prmtn), 0)
255: ,NVL(SUM(fte_prmtn), 0)
256: FROM hri_mds_wrkfc_mnth_ct
257: WHERE asg_assgnmnt_fk = p_assignment_id
258: AND time_month_snp_fk BETWEEN to_number(to_char(p_effective_start_date, 'YYYYQMM'))
259: AND to_number(to_char(p_effective_end_date, 'YYYYQMM'));
260: