APPS.HRI_OPL_EVENT_CAPTURE dependencies on HRI_MB_ASGN_EVENTS_CT

Line 489: -- per_all_assignments_f but does exist in hri_mb_asgn_events_ct

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

Line 514: FROM hri_mb_asgn_events_ct asg

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

Line 520: FROM hri_mb_asgn_events_ct asgn

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

Line 2470: p_process_table_name => 'HRI_MB_ASGN_EVENTS_CT');

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