[Home] [Help]
204: UPDATE hri_map_sup_wrkfc_asg asg_dlt
205: SET (asg_dlt.job_fmly_code , asg_dlt.job_fnctn_code) =
206: (SELECT jobh.job_fmly_code ,
207: jobh.job_fnctn_code
208: FROM hri_cs_jobh_ct jobh
209: WHERE jobh.job_id = asg_dlt.job_id)
210: WHERE (assignment_id, evts_effective_end_date) in
211: (SELECT asgn.assignment_id,
212: asgn.effective_change_end_date
648: ,sub_assignment_id sub_assignment_id
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
792: ,sub_assignment_id sub_assignment_id
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
1140: --
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
1284: --
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
1681: ,sub_assignment_id sub_assignment_id' ||
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
1811: ,sub_assignment_id sub_assignment_id' ||
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