DBA Data[Home] [Help]

APPS.PA_BUDGET_ACCOUNT_PKG dependencies on DUAL

Line 409: from dual where exists (select 1

405: Begin -- II
406:
407: Select 'Y'
408: into l_txn_exists_against_project
409: from dual where exists (select 1
410: from pa_bc_balances
411: where budget_version_id = l_Prev_Budget_Version_ID
412: and balance_type <> 'BGT');
413: Exception

Line 418: from dual where exists (select 1

414: When no_data_found then
415: Begin -- III
416: Select 'Y'
417: into l_txn_exists_against_project
418: from dual where exists (select 1
419: from pa_bc_packets
420: where budget_version_id = l_Prev_Budget_Version_ID
421: and status_code in ('P','Z','A','I'));
422: Exception