APPS.HRI_OPL_EVENT_CAPTURE dependencies on HRI_MB_ASGN_EVENTS_CT

Line 492: -- per_all_assignments_f but does exist in hri_mb_asgn_events_ct

488: -- Note: extension starts one day after the projected assignment end specified
489: -- in the assignment record
490: --
491: -- Bug 4533293 - return event date (using NVL) if no projected end date exists in
492: -- per_all_assignments_f but does exist in hri_mb_asgn_events_ct
493: --
494: CURSOR c_extsn_strt_dt IS
495: SELECT asgn.person_id, NVL(min(asgn.projected_assignment_end) + 1, p_effective_date)
496: FROM per_all_assignments_f asgn

Line 517: FROM hri_mb_asgn_events_ct asg

513: -- or previous extension removed
514: --
515: HAVING NVL(min(asgn.projected_assignment_end), g_end_of_time) <>
516: (SELECT NVL(MIN(asg.pow_extn_strt_dt) - 1, g_end_of_time)
517: FROM hri_mb_asgn_events_ct asg
518: WHERE asg.assignment_id = p_assignment_id);
519: --
520: CURSOR c_othr_prmry_asg IS
521: SELECT assignment_id,

Line 523: FROM hri_mb_asgn_events_ct asgn

519: --
520: CURSOR c_othr_prmry_asg IS
521: SELECT assignment_id,
522: least(min(asgn.effective_change_date),l_extnsn_strt_dt) change_date
523: FROM hri_mb_asgn_events_ct asgn
524: WHERE asgn.person_id = l_person_id
525: AND pow_extn_strt_dt is not null
526: AND asgn.pow_extn_strt_dt <> l_extnsn_strt_dt
527: AND assignment_id <> p_assignment_id

Line 2473: p_process_table_name => 'HRI_MB_ASGN_EVENTS_CT');

2469: (p_parameter_name => 'FULL_REFRESH',
2470: p_process_table_name => 'HRI_CS_SUPH');
2471: l_asgn_full_refresh := hri_oltp_conc_param.get_parameter_value
2472: (p_parameter_name => 'FULL_REFRESH',
2473: p_process_table_name => 'HRI_MB_ASGN_EVENTS_CT');
2474: l_spst_full_refresh := hri_oltp_conc_param.get_parameter_value
2475: (p_parameter_name => 'FULL_REFRESH',
2476: p_process_table_name => 'HRI_CL_WKR_SUP_STATUS_CT');
2477: l_absc_full_refresh := hri_oltp_conc_param.get_parameter_value