APPS.OPI_DBI_COMMON_MOD_INCR_PKG dependencies on DUAL

Line 476: FROM DUAL;

472: -- horizon between OPM and OPI updates.
473: l_stmt_id := 35;
474: SELECT sysdate
475: INTO l_to_bound_date
476: FROM DUAL;
477:
478: -- It is possible that a new discrete org was defined in
479: -- MTL_PARAMETERS since the last incremental run. This org must
480: -- get a record in current log table, OPI_DBI_RUN_LOG_CURR so that

Line 550: FROM (SELECT JOB_TXN_ETL etl_id FROM dual

546: s_program_id,
547: s_program_login_id,
548: s_program_application_id,
549: s_request_id
550: FROM (SELECT JOB_TXN_ETL etl_id FROM dual
551: ) etls,
552: (SELECT organization_id
553: FROM mtl_parameters
554: WHERE process_enabled_flag <> 'Y' -- not OPM org

Line 1143: FROM dual

1139: l_stmt_id := 5;
1140: BEGIN
1141: SELECT 1
1142: INTO l_exists
1143: FROM dual
1144: WHERE (EXISTS (SELECT source
1145: FROM opi_dbi_run_log_curr
1146: WHERE rownum = 1));
1147:

Line 1237: FROM dual

1233: l_stmt_id := 10;
1234: BEGIN
1235: SELECT 1
1236: INTO l_exists
1237: FROM dual
1238: WHERE (EXISTS (SELECT start_txn_id
1239: FROM opi_dbi_run_log_curr
1240: WHERE start_txn_id IS NULL
1241: AND source = p_source

Line 1353: FROM dual

1349: l_stmt_id := 20;
1350: BEGIN
1351: SELECT 1
1352: INTO l_exists
1353: FROM dual
1354: WHERE (EXISTS (SELECT from_bound_date
1355: FROM opi_dbi_run_log_curr
1356: WHERE from_bound_date IS NULL
1357: AND source = p_source

Line 1372: FROM dual

1368: l_stmt_id := 30;
1369: BEGIN
1370: SELECT 1
1371: INTO l_exists
1372: FROM dual
1373: WHERE (EXISTS (SELECT to_bound_date
1374: FROM opi_dbi_run_log_curr
1375: WHERE to_bound_date IS NULL
1376: AND source = p_source