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_SUP_WRKFC_ASG dependencies on HRI_CS_SUPH

Line 656: ,hri_cs_suph suph

652: ,hri_cs_jobh_ct jobh
653: ,hri_cs_geo_lochr_ct geoh
654: ,hri_cs_prsntyp_ct prsn
655: ,hri_cs_job_job_role_ct rolj
656: ,hri_cs_suph suph
657: WHERE suph.sub_person_id = evts.supervisor_id
658: AND suph.sup_invalid_flag_code = 'N'
659: AND (evts.effective_change_date BETWEEN suph.effective_start_date AND suph.effective_end_date
660: OR suph.effective_start_date BETWEEN evts.effective_change_date AND evts.effective_change_end_date)

Line 800: ,hri_cs_suph suph

796: ,hri_cs_jobh_ct jobh
797: ,hri_cs_geo_lochr_ct geoh
798: ,hri_cs_prsntyp_ct prsn
799: ,hri_cs_job_job_role_ct rolj
800: ,hri_cs_suph suph
801: WHERE suph.sub_person_id = evts.supervisor_id
802: AND suph.sup_invalid_flag_code = 'N'
803: AND (suph.effective_end_date BETWEEN evts.effective_change_date AND evts.effective_change_end_date
804: OR evts.effective_change_end_date BETWEEN suph.effective_start_date AND suph.effective_end_date)

Line 1146: ,hri_cs_suph suph

1142: FROM
1143: hri_mb_asgn_events_ct evts
1144: ,hri_cs_jobh_ct jobh
1145: ,hri_cs_geo_lochr_ct geoh
1146: ,hri_cs_suph suph
1147: ,hri_cs_prsntyp_ct prsn
1148: ,hri_cs_job_job_role_ct rolj
1149: ,hri_eq_asg_sup_wrfc eq
1150: WHERE suph.sub_person_id = evts.supervisor_id

Line 1290: ,hri_cs_suph suph

1286: FROM
1287: hri_mb_asgn_events_ct evts
1288: ,hri_cs_jobh_ct jobh
1289: ,hri_cs_geo_lochr_ct geoh
1290: ,hri_cs_suph suph
1291: ,hri_cs_prsntyp_ct prsn
1292: ,hri_cs_job_job_role_ct rolj
1293: ,hri_eq_asg_sup_wrfc eq
1294: WHERE suph.sub_person_id = evts.supervisor_id

Line 1689: ,hri_cs_suph suph

1685: ,hri_cs_jobh_ct jobh
1686: ,hri_cs_geo_lochr_ct geoh
1687: ,hri_cs_prsntyp_ct prsn
1688: ,hri_cs_job_job_role_ct rolj
1689: ,hri_cs_suph suph
1690: WHERE suph.sub_person_id = evts.supervisor_id
1691: AND suph.sup_invalid_flag_code = ''N''
1692: AND (evts.effective_change_date BETWEEN suph.effective_start_date
1693: AND suph.effective_end_date

Line 1819: ,hri_cs_suph suph

1815: ,hri_cs_jobh_ct jobh
1816: ,hri_cs_geo_lochr_ct geoh
1817: ,hri_cs_prsntyp_ct prsn
1818: ,hri_cs_job_job_role_ct rolj
1819: ,hri_cs_suph suph
1820: WHERE suph.sub_person_id = evts.supervisor_id
1821: AND suph.sup_invalid_flag_code = ''N''
1822: AND (suph.effective_end_date BETWEEN evts.effective_change_date
1823: AND evts.effective_change_end_date