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_GEO_LOCHR_CT

Line 284: FROM hri_cs_geo_lochr_ct geoh

280: (SELECT geoh.area_code,
281: geoh.country_code,
282: geoh.region_code,
283: geoh.city_cid
284: FROM hri_cs_geo_lochr_ct geoh
285: WHERE geoh.location_id = asg_dlt.location_id)
286: WHERE (assignment_id, evts_effective_end_date) IN
287: (SELECT asgn.assignment_id,
288: asgn.effective_change_end_date

Line 653: ,hri_cs_geo_lochr_ct geoh

649: FROM
650: hri_eq_asg_sup_wrfc eq
651: ,hri_mb_asgn_events_ct evts
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

Line 797: ,hri_cs_geo_lochr_ct geoh

793: FROM
794: hri_eq_asg_sup_wrfc eq
795: ,hri_mb_asgn_events_ct evts
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

Line 1145: ,hri_cs_geo_lochr_ct geoh

1141: ,sub_assignment_id sub_assignment_id
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

Line 1289: ,hri_cs_geo_lochr_ct geoh

1285: ,sub_assignment_id sub_assignment_id
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

Line 1686: ,hri_cs_geo_lochr_ct geoh

1682: l_part_col_value || '
1683: FROM
1684: hri_mb_asgn_events_ct evts
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

Line 1816: ,hri_cs_geo_lochr_ct geoh

1812: l_part_col_value || '
1813: FROM
1814: hri_mb_asgn_events_ct evts
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