[Home] [Help]
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
213: FROM hri_mb_asgn_events_ct asgn,
214: hri_eq_asg_sup_wrfc eq
215: WHERE asgn.job_id = eq.source_id
216: AND eq.source_type = 'JOB'
217: AND eq.source_id BETWEEN p_start_object_id AND p_end_object_id);
247: AND jbrl.primary_role_for_job_flag = 'Y')
248: WHERE (assignment_id, evts_effective_end_date) IN
249: (SELECT asgn.assignment_id,
250: asgn.effective_change_end_date
251: FROM hri_mb_asgn_events_ct asgn,
252: hri_eq_asg_sup_wrfc eq
253: WHERE asgn.job_id = eq.source_id
254: AND eq.source_type = 'PRIMARY_JOB_ROLE'
255: AND eq.source_id BETWEEN p_start_object_id AND p_end_object_id);
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
289: FROM hri_mb_asgn_events_ct asgn,
290: hri_eq_asg_sup_wrfc eq
291: WHERE asgn.location_id = eq.source_id
292: AND eq.source_type = 'LOCATION'
293: AND eq.source_id BETWEEN p_start_object_id AND p_end_object_id);
320: prsn.wkth_lvl1_sk_fk,
321: prsn.wkth_lvl2_sk_fk,
322: prsn.wkth_wktyp_code
323: FROM hri_cs_prsntyp_ct prsn,
324: hri_mb_asgn_events_ct asgn
325: WHERE prsn.prsntyp_sk_pk = asgn.prsntyp_sk_fk
326: AND asgn.assignment_id = asg_dlt.assignment_id
327: AND ROWNUM < 2
328: )
328: )
329: WHERE (assignment_id, evts_effective_end_date) IN
330: (SELECT asgn.assignment_id,
331: asgn.effective_change_end_date
332: FROM hri_mb_asgn_events_ct asgn,
333: hri_eq_asg_sup_wrfc eq
334: WHERE asgn.prsntyp_sk_fk = eq.source_id
335: AND eq.source_type = 'PERSON_TYPE'
336: AND eq.source_id BETWEEN p_start_object_id AND p_end_object_id);
647: --
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
791: --
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
1139: -- Incremental Changes
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
1283: -- Incremental Changes
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
1680: ,:l_current_time
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
1810: ,:l_current_time
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
1926: --
1927: p_sqlstr :=
1928: 'SELECT DISTINCT
1929: assignment_id object_id
1930: FROM hri_mb_asgn_events_ct
1931: ORDER BY assignment_id';
1932: --
1933: -- End of Full Refresh Section
1934: -- -------------------------------------------------------------------------
2143: max(object_id) end_object_id
2144: FROM (SELECT hri_opl_multi_thread.get_next_mthd_range_id(rownum,200) mthd_range_id
2145: ,object_id
2146: FROM (SELECT DISTINCT assignment_id object_id
2147: FROM hri_mb_asgn_events_ct
2148: ORDER BY assignment_id)
2149: )
2150: GROUP BY mthd_range_id;
2151: --