APPS.XLA_BALANCES_CALC_PKG dependencies on DUAL

Line 371: FROM dual;

367: BULK COLLECT INTO
368: g_ledger_array
369: , g_application_array
370: , g_accounting_batch_array
371: FROM dual;
372:
373: FORALL i in g_ledger_array.FIRST..g_ledger_array.LAST
374: INSERT INTO xla_bal_concurrency_control
375: (ledger_id

Line 397: FROM dual;

393: select
394: p_ledger_id
395: BULK COLLECT INTO
396: g_ledger_array
397: FROM dual;
398:
399: FORALL i in g_ledger_array.FIRST..g_ledger_array.LAST
400: INSERT INTO xla_bal_concurrency_control
401: (ledger_id

Line 3385: FROM dual

3381: -- Bug12613841 modified cursor csr_bal_count to add where effective_period_num is null
3382: CURSOR csr_bal_count
3383: IS
3384: SELECT COUNT(1) bal_count
3385: FROM dual
3386: WHERE EXISTS (SELECT 1 FROM xla_control_balances where effective_period_num is null)
3387: OR EXISTS (SELECT 1 FROM xla_ac_balances where effective_period_num is null);
3388:
3389: CURSOR csr_bal_sob_count(p_ledger_id NUMBER)

Line 3392: FROM dual

3388:
3389: CURSOR csr_bal_sob_count(p_ledger_id NUMBER)
3390: IS
3391: SELECT COUNT(1) bal_sob_count
3392: FROM dual
3393: WHERE EXISTS (SELECT 1 FROM xla_control_balances WHERE ledger_id = p_ledger_id)
3394: OR EXISTS (SELECT 1 FROM xla_ac_balances WHERE ledger_id = p_ledger_id);
3395:
3396: -- Bug12613841 added the cursor csr_xlo_not_null_count

Line 4909: FROM dual

4905: ,p_module => l_log_module);
4906:
4907: END IF;
4908: l_query := 'SELECT count(1)
4909: FROM dual
4910: where exists(select 1
4911: from xla_ae_lines xal
4912: ,xla_ae_line_acs xac
4913: ,gl_period_statuses gps1