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 DUAL

Line 546: ,(SELECT 'Y' sup_directs_only_flag FROM dual

542: ,hri_mds_wrkfc_mnth_ct wevt
543: ,hri_cs_geo_lochr_ct ctr
544: ,hri_cs_jobh_ct jobh
545: ,hri_cs_prsntyp_ct ptyp
546: ,(SELECT 'Y' sup_directs_only_flag FROM dual
547: UNION ALL
548: SELECT 'N' sup_directs_only_flag FROM dual
549: ) dcts
550: WHERE chn.mgrs_person_fk = p_manager_id

Line 548: SELECT 'N' sup_directs_only_flag FROM dual

544: ,hri_cs_jobh_ct jobh
545: ,hri_cs_prsntyp_ct ptyp
546: ,(SELECT 'Y' sup_directs_only_flag FROM dual
547: UNION ALL
548: SELECT 'N' sup_directs_only_flag FROM dual
549: ) dcts
550: WHERE chn.mgrs_person_fk = p_manager_id
551: AND p_snapshot_date BETWEEN chn.mgrs_date_start
552: AND chn.mgrs_date_end