APPS.RCI_UNMTG_RISKS_ETL_PKG dependencies on RCI_DR_INC

Line 95: FROM rci_dr_inc

91: l_stmt_id := 0;
92:
93: SELECT last_run_date
94: into l_last_run_date
95: FROM rci_dr_inc
96: WHERE fact_name = p_fact_name ;
97:
98: RETURN l_last_run_date;
99: EXCEPTION

Line 184: DELETE FROM rci_dr_inc where fact_name = 'RCI_ORG_CERT_RISKS_F';

180: x_global_start_date => g_global_start_date
181: ,x_rci_schema => g_rci_schema);
182:
183: l_stmnt_id := 10;
184: DELETE FROM rci_dr_inc where fact_name = 'RCI_ORG_CERT_RISKS_F';
185:
186:
187: l_stmnt_id := 20;
188: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_CERT_RISKS_F');

Line 289: INSERT INTO rci_dr_inc( fact_name

285: and acv.certification_period_set_name = agpv.period_set_name;
286:
287: l_stmnt_id :=40;
288:
289: INSERT INTO rci_dr_inc( fact_name
290: ,last_run_date
291: ,created_by
292: ,creation_date
293: ,last_update_date

Line 363: DELETE FROM rci_dr_inc where fact_name = 'RCI_ORG_CERT_RISKS_F';

359: x_global_start_date => g_global_start_date
360: ,x_rci_schema => g_rci_schema);
361:
362: l_stmnt_id := 10;
363: DELETE FROM rci_dr_inc where fact_name = 'RCI_ORG_CERT_RISKS_F';
364:
365:
366: l_stmnt_id := 20;
367: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_ORG_CERT_RISKS_F');

Line 497: INSERT INTO rci_dr_inc( fact_name

493: l_stmnt_id :=50;
494:
495:
496: l_stmnt_id :=60;
497: INSERT INTO rci_dr_inc( fact_name
498: ,last_run_date
499: ,created_by
500: ,creation_date
501: ,last_update_date

Line 684: UPDATE rci_dr_inc

680: and acv.certification_period_set_name = agpv.period_set_name;
681:
682: l_stmnt_id :=50;
683:
684: UPDATE rci_dr_inc
685: SET last_run_date = l_run_date
686: ,last_update_date = sysdate
687: ,last_updated_by = l_user_id
688: ,last_update_login = l_login_id