APPS.HRI_OPL_SUP_STATUS_HST dependencies on HRI_MB_ASGN_EVENTS_CT

Line 300: FROM hri_mb_asgn_events_ct evt

296: ELSE
297: evt.supervisor_id
298: END event_supervisor_id,
299: evt.effective_change_date effective_date
300: FROM hri_mb_asgn_events_ct evt
301: WHERE (
302: (--
303: -- get only those asg records which have had a
304: -- change in supervisor

Line 328: FROM hri_mb_asgn_events_ct evt

324: -- supervisory status. Get all the transfer out events
325: --
326: SELECT evt.supervisor_prv_id event_supervisor_id,
327: evt.effective_change_date effective_date
328: FROM hri_mb_asgn_events_ct evt
329: WHERE (
330: (
331: (supervisor_change_ind = 1
332: OR worker_term_ind = 1

Line 532: FROM hri_mb_asgn_events_ct evt,

528: ELSE
529: evt.supervisor_id
530: END event_supervisor_id,
531: evt.effective_change_date effective_date
532: FROM hri_mb_asgn_events_ct evt,
533: hri_eq_sprvsr_hstry_chgs eq
534: WHERE (
535: (--
536: -- get only those asg records which have had a

Line 562: FROM hri_mb_asgn_events_ct evt,

558: -- supervisory status. Get all the transfer out events
559: --
560: SELECT evt.supervisor_prv_id event_supervisor_id,
561: evt.effective_change_date effective_date
562: FROM hri_mb_asgn_events_ct evt,
563: hri_eq_sprvsr_hstry_chgs eq
564: WHERE (
565: (
566: (supervisor_change_ind = 1

Line 766: FROM hri_mb_asgn_events_ct evt

762: -- can affects his supervisory status
763: --
764: SELECT evt.supervisor_id event_supervisor_id,
765: evt.effective_change_date effective_date
766: FROM hri_mb_asgn_events_ct evt
767: WHERE (worker_hire_ind = 1
768: OR post_hire_asgn_start_ind = 1
769: OR supervisor_change_ind = 1
770: OR asg_rtrspctv_strt_event_ind = 1)

Line 780: FROM hri_mb_asgn_events_ct evt

776: -- supervisory status. Get all the transfer out events
777: --
778: SELECT evt.supervisor_prv_id event_supervisor_id,
779: evt.effective_change_date effective_date
780: FROM hri_mb_asgn_events_ct evt
781: WHERE (supervisor_change_ind = 1
782: OR worker_term_ind = 1
783: OR pre_sprtn_asgn_end_ind = 1)
784: AND evt.supervisor_prv_id <> -1

Line 969: FROM hri_mb_asgn_events_ct evt,

965: -- can affects his supervisory status
966: --
967: SELECT evt.supervisor_id event_supervisor_id,
968: evt.effective_change_date effective_date
969: FROM hri_mb_asgn_events_ct evt,
970: hri_eq_sprvsr_hstry_chgs eq
971: WHERE (worker_hire_ind = 1
972: OR post_hire_asgn_start_ind = 1
973: OR supervisor_change_ind = 1

Line 985: FROM hri_mb_asgn_events_ct evt,

981: -- supervisory status. Get all the transfer out events
982: --
983: SELECT evt.supervisor_prv_id event_supervisor_id,
984: evt.effective_change_date effective_date
985: FROM hri_mb_asgn_events_ct evt,
986: hri_eq_sprvsr_hstry_chgs eq
987: WHERE (supervisor_change_ind = 1
988: OR worker_term_ind = 1
989: OR pre_sprtn_asgn_end_ind = 1)

Line 1106: -- NOTE - THIS MUST BE CALLED BEFORE hri_mb_asgn_events_ct IS REFRESHED

1102: --
1103: dbg('Case A');
1104: --
1105: -- Insert previous supervisors
1106: -- NOTE - THIS MUST BE CALLED BEFORE hri_mb_asgn_events_ct IS REFRESHED
1107: --
1108: INSERT /*+ APPEND */ INTO hri_eq_sprvsr_hstry_chgs
1109: (person_id
1110: ,erlst_evnt_effective_date

Line 1118: ,hri_mb_asgn_events_ct evt

1114: ,eq.erlst_evnt_effective_date
1115: ,'DERIVED'
1116: FROM
1117: hri_eq_sprvsr_hstry_chgs eq
1118: ,hri_mb_asgn_events_ct evt
1119: WHERE eq.assignment_id = evt.assignment_id
1120: AND evt.effective_change_end_date >= eq.erlst_evnt_effective_date
1121: AND eq.source_code IS NULL
1122: AND NOT EXISTS