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_JOB_JOB_ROLE_CT

Line 245: FROM hri_cs_job_job_role_ct jbrl

241: --
242: UPDATE hri_map_sup_wrkfc_asg asg_dlt
243: SET asg_dlt.primary_job_role_code =
244: (SELECT jbrl.job_role_code
245: FROM hri_cs_job_job_role_ct jbrl
246: WHERE jbrl.job_id = asg_dlt.job_id
247: AND jbrl.primary_role_for_job_flag = 'Y')
248: WHERE (assignment_id, evts_effective_end_date) IN
249: (SELECT asgn.assignment_id,

Line 655: ,hri_cs_job_job_role_ct rolj

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
658: AND suph.sup_invalid_flag_code = 'N'
659: AND (evts.effective_change_date BETWEEN suph.effective_start_date AND suph.effective_end_date

Line 799: ,hri_cs_job_job_role_ct rolj

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
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

Line 1148: ,hri_cs_job_job_role_ct rolj

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
1151: AND suph.sup_invalid_flag_code = 'N'
1152: AND (evts.effective_change_date BETWEEN suph.effective_start_date AND suph.effective_end_date

Line 1292: ,hri_cs_job_job_role_ct rolj

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
1295: AND suph.sup_invalid_flag_code = 'N'
1296: AND (suph.effective_end_date BETWEEN evts.effective_change_date AND evts.effective_change_end_date

Line 1688: ,hri_cs_job_job_role_ct rolj

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
1691: AND suph.sup_invalid_flag_code = ''N''
1692: AND (evts.effective_change_date BETWEEN suph.effective_start_date

Line 1818: ,hri_cs_job_job_role_ct rolj

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
1821: AND suph.sup_invalid_flag_code = ''N''
1822: AND (suph.effective_end_date BETWEEN evts.effective_change_date