eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FUNDS_CONTROL_UTILS dependencies on DUAL

Line 1223: from dual

1219: If g_current_baseline_bvid <> -2 then
1220: Begin
1221: select 'Y'
1222: into g_txn_exists_for_bvid
1223: from dual
1224: where exists (select 1
1225: from pa_bc_balances pbb
1226: where pbb.budget_version_id = g_current_baseline_bvid
1227: and pbb.project_id = g_api_project_id

Line 1235: from dual

1231:
1232: Begin
1233: select 'Y'
1234: into g_txn_exists_for_bvid
1235: from dual
1236: where exists (select 1
1237: from pa_bc_packets pbb
1238: where pbb.project_id = g_api_project_id
1239: and pbb.status_code in ('A','P','I','Z') );

Line 1720: from dual

1716: Begin
1717:
1718: Select 'N'
1719: into l_allowed_flag
1720: from dual
1721: where exists(select 1
1722: from pa_bc_balances pbb
1723: where pbb.budget_version_id = p_budget_version_id
1724: and pbb.task_id = p_task_id

Line 1734: from dual

1730: Exception
1731: When no_data_found then
1732: Select 'N'
1733: into l_allowed_flag
1734: from dual
1735: where exists(select 1
1736: from pa_bc_packets pbc
1737: where pbc.budget_version_id = p_budget_version_id
1738: and pbc.bud_task_id = p_task_id

Line 1752: from dual

1748: Begin
1749:
1750: Select 'N'
1751: into l_allowed_flag
1752: from dual
1753: where exists(select 1
1754: from pa_bc_balances pbb
1755: where pbb.budget_version_id = p_budget_version_id
1756: and pbb.top_task_id = p_top_task_id

Line 1766: from dual

1762: Exception
1763: When no_data_found then
1764: Select 'N'
1765: into l_allowed_flag
1766: from dual
1767: where exists(select 1
1768: from pa_bc_packets pbc
1769: where pbc.budget_version_id = p_budget_version_id
1770: and pbc.bud_task_id = p_top_task_id

Line 1784: from dual

1780: Begin
1781:
1782: Select 'N'
1783: into l_allowed_flag
1784: from dual
1785: where exists(select 1
1786: from pa_bc_balances pbb
1787: where pbb.budget_version_id = p_budget_version_id
1788: and nvl(pbb.parent_member_id,-99) = nvl(p_parent_resource_id,-99)

Line 1797: from dual

1793: Exception
1794: When no_data_found then
1795: Select 'N'
1796: into l_allowed_flag
1797: from dual
1798: where exists(select 1
1799: from pa_bc_packets pbc
1800: where pbc.budget_version_id = p_budget_version_id
1801: and pbc.bud_resource_list_member_id = p_resource_list_member_id

Line 1821: from dual

1817: Begin
1818:
1819: Select 'N'
1820: into l_allowed_flag
1821: from dual
1822: where exists(select 1
1823: from pa_bc_packets pbc
1824: where pbc.budget_version_id = p_budget_version_id
1825: and pbc.bud_task_id = p_task_id

Line 1833: from dual

1829: Exception
1830: When no_data_found then
1831: Select 'N'
1832: into l_allowed_flag
1833: from dual
1834: where exists(select 1
1835: from pa_bc_balances pbb
1836: where pbb.budget_version_id = p_budget_version_id
1837: and pbb.task_id = p_task_id

Line 1853: from dual

1849: Begin
1850:
1851: Select 'N'
1852: into l_allowed_flag
1853: from dual
1854: where exists(select 1
1855: from pa_bc_packets pbc
1856: where pbc.budget_version_id = p_budget_version_id
1857: and pbc.bud_task_id = p_top_task_id

Line 1865: from dual

1861: Exception
1862: When no_data_found then
1863: Select 'N'
1864: into l_allowed_flag
1865: from dual
1866: where exists(select 1
1867: from pa_bc_balances pbb
1868: where pbb.budget_version_id = p_budget_version_id
1869: and pbb.top_task_id = p_top_task_id

Line 1885: from dual

1881: Begin
1882:
1883: Select 'N'
1884: into l_allowed_flag
1885: from dual
1886: where exists(select 1
1887: from pa_bc_packets pbc
1888: where pbc.budget_version_id = p_budget_version_id
1889: and pbc.bud_resource_list_member_id = p_resource_list_member_id

Line 1896: from dual

1892: Exception
1893: When no_data_found then
1894: Select 'N'
1895: into l_allowed_flag
1896: from dual
1897: where exists(select 1
1898: from pa_bc_balances pbb
1899: where pbb.budget_version_id = p_budget_version_id
1900: and nvl(pbb.parent_member_id,-99) = nvl(p_parent_resource_id,-99)

Line 2126: FROM dual

2122: AND GL.closing_status = DECODE(pbv.budget_version_id,pa_budget_fund_pkg.g_cost_prev_bvid,'C',GL.closing_status)
2123: AND bc.budget_version_id = pbv.budget_version_id
2124: AND BEM.Budget_Entry_Method_Code = PBV.Budget_Entry_Method_Code
2125: AND pbv.budget_version_id in (SELECT p_bud_ver_id
2126: FROM dual
2127: UNION ALL
2128: -- Bug 5206341 :Transactions in closed period are picked for latest budget details stamping
2129: SELECT pa_budget_fund_pkg.g_cost_prev_bvid
2130: FROM dual

Line 2130: FROM dual

2126: FROM dual
2127: UNION ALL
2128: -- Bug 5206341 :Transactions in closed period are picked for latest budget details stamping
2129: SELECT pa_budget_fund_pkg.g_cost_prev_bvid
2130: FROM dual
2131: WHERE l_closed_prd_exists = 'Y');
2132:
2133:
2134: l_ccid pa_bc_packets.budget_ccid%type := null;

Line 2606: FROM dual

2602: AND decode(nvl(AID.cancellation_flag,'N'), 'Y', decode(AID.Parent_Reversal_id, null,'N','Y'),'N') = 'Y';
2603:
2604: CURSOR C_check_main_cancelled_dist IS
2605: SELECT 'Y'
2606: FROM dual
2607: WHERE exists ( select 1
2608: from ap_invoice_distributions_all aid
2609: where aid.invoice_id = p_invoice_id
2610: and aid.Parent_Reversal_id = p_invoice_distribution_id);