APPS.HRI_OPL_EVENT_CAPTURE dependencies on HRI_CS_SUPH

Line 377: WHERE object_name = 'HRI_CS_SUPH'

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

Line 382: WHERE object_name= 'HRI_CS_SUPH'

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

Line 389: FROM hri_cs_suph;

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

Line 2467: p_process_table_name => 'HRI_CS_SUPH');

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