APPS.HRI_OPL_EVENT_CAPTURE dependencies on HRI_CS_SUPH

Line 380: WHERE object_name = 'HRI_CS_SUPH'

376: --
377: CURSOR c_last_full_suph_col_run IS
378: SELECT period_from
379: FROM bis_refresh_log
380: WHERE object_name = 'HRI_CS_SUPH'
381: AND status='SUCCESS'
382: AND attribute1 = 'Y'
383: AND last_update_date =( SELECT max(last_update_date)
384: FROM bis_refresh_log

Line 385: WHERE object_name= 'HRI_CS_SUPH'

381: AND status='SUCCESS'
382: AND attribute1 = 'Y'
383: AND last_update_date =( SELECT max(last_update_date)
384: FROM bis_refresh_log
385: WHERE object_name= 'HRI_CS_SUPH'
386: AND status='SUCCESS'
387: AND attribute1 = 'Y')
388: ORDER BY last_update_date DESC;
389: --

Line 392: FROM hri_cs_suph;

388: ORDER BY last_update_date DESC;
389: --
390: CURSOR c_min_suph_date IS
391: SELECT min(effective_start_date)
392: FROM hri_cs_suph;
393: --
394: BEGIN
395: --
396: -- 3906029 The event date to be populated in the supervisor hierarchy

Line 2470: p_process_table_name => 'HRI_CS_SUPH');

2466: dbg('Getting full refresh value for each of dependent tables ...');
2467: --
2468: l_suph_full_refresh := hri_oltp_conc_param.get_parameter_value
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