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 1072: from dual

1068: If g_current_baseline_bvid <> -2 then
1069: Begin
1070: select 'Y'
1071: into g_txn_exists_for_bvid
1072: from dual
1073: where exists (select 1
1074: from pa_bc_balances pbb
1075: where pbb.budget_version_id = g_current_baseline_bvid
1076: and pbb.project_id = g_api_project_id

Line 1084: from dual

1080:
1081: Begin
1082: select 'Y'
1083: into g_txn_exists_for_bvid
1084: from dual
1085: where exists (select 1
1086: from pa_bc_packets pbb
1087: where pbb.project_id = g_api_project_id
1088: and pbb.status_code in ('A','P','I','Z') );

Line 1569: from dual

1565: Begin
1566:
1567: Select 'N'
1568: into l_allowed_flag
1569: from dual
1570: where exists(select 1
1571: from pa_bc_balances pbb
1572: where pbb.budget_version_id = p_budget_version_id
1573: and pbb.task_id = p_task_id

Line 1583: from dual

1579: Exception
1580: When no_data_found then
1581: Select 'N'
1582: into l_allowed_flag
1583: from dual
1584: where exists(select 1
1585: from pa_bc_packets pbc
1586: where pbc.budget_version_id = p_budget_version_id
1587: and pbc.bud_task_id = p_task_id

Line 1601: from dual

1597: Begin
1598:
1599: Select 'N'
1600: into l_allowed_flag
1601: from dual
1602: where exists(select 1
1603: from pa_bc_balances pbb
1604: where pbb.budget_version_id = p_budget_version_id
1605: and pbb.top_task_id = p_top_task_id

Line 1615: from dual

1611: Exception
1612: When no_data_found then
1613: Select 'N'
1614: into l_allowed_flag
1615: from dual
1616: where exists(select 1
1617: from pa_bc_packets pbc
1618: where pbc.budget_version_id = p_budget_version_id
1619: and pbc.bud_task_id = p_top_task_id

Line 1633: from dual

1629: Begin
1630:
1631: Select 'N'
1632: into l_allowed_flag
1633: from dual
1634: where exists(select 1
1635: from pa_bc_balances pbb
1636: where pbb.budget_version_id = p_budget_version_id
1637: and nvl(pbb.parent_member_id,-99) = nvl(p_parent_resource_id,-99)

Line 1646: from dual

1642: Exception
1643: When no_data_found then
1644: Select 'N'
1645: into l_allowed_flag
1646: from dual
1647: where exists(select 1
1648: from pa_bc_packets pbc
1649: where pbc.budget_version_id = p_budget_version_id
1650: and pbc.bud_resource_list_member_id = p_resource_list_member_id

Line 1670: from dual

1666: Begin
1667:
1668: Select 'N'
1669: into l_allowed_flag
1670: from dual
1671: where exists(select 1
1672: from pa_bc_packets pbc
1673: where pbc.budget_version_id = p_budget_version_id
1674: and pbc.bud_task_id = p_task_id

Line 1682: from dual

1678: Exception
1679: When no_data_found then
1680: Select 'N'
1681: into l_allowed_flag
1682: from dual
1683: where exists(select 1
1684: from pa_bc_balances pbb
1685: where pbb.budget_version_id = p_budget_version_id
1686: and pbb.task_id = p_task_id

Line 1702: from dual

1698: Begin
1699:
1700: Select 'N'
1701: into l_allowed_flag
1702: from dual
1703: where exists(select 1
1704: from pa_bc_packets pbc
1705: where pbc.budget_version_id = p_budget_version_id
1706: and pbc.bud_task_id = p_top_task_id

Line 1714: from dual

1710: Exception
1711: When no_data_found then
1712: Select 'N'
1713: into l_allowed_flag
1714: from dual
1715: where exists(select 1
1716: from pa_bc_balances pbb
1717: where pbb.budget_version_id = p_budget_version_id
1718: and pbb.top_task_id = p_top_task_id

Line 1734: from dual

1730: Begin
1731:
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_resource_list_member_id = p_resource_list_member_id

Line 1745: from dual

1741: Exception
1742: When no_data_found then
1743: Select 'N'
1744: into l_allowed_flag
1745: from dual
1746: where exists(select 1
1747: from pa_bc_balances pbb
1748: where pbb.budget_version_id = p_budget_version_id
1749: and nvl(pbb.parent_member_id,-99) = nvl(p_parent_resource_id,-99)

Line 1975: FROM dual

1971: AND GL.closing_status = DECODE(pbv.budget_version_id,pa_budget_fund_pkg.g_cost_prev_bvid,'C',GL.closing_status)
1972: AND bc.budget_version_id = pbv.budget_version_id
1973: AND BEM.Budget_Entry_Method_Code = PBV.Budget_Entry_Method_Code
1974: AND pbv.budget_version_id in (SELECT p_bud_ver_id
1975: FROM dual
1976: UNION ALL
1977: -- Bug 5206341 :Transactions in closed period are picked for latest budget details stamping
1978: SELECT pa_budget_fund_pkg.g_cost_prev_bvid
1979: FROM dual

Line 1979: FROM dual

1975: FROM dual
1976: UNION ALL
1977: -- Bug 5206341 :Transactions in closed period are picked for latest budget details stamping
1978: SELECT pa_budget_fund_pkg.g_cost_prev_bvid
1979: FROM dual
1980: WHERE l_closed_prd_exists = 'Y');
1981:
1982:
1983: l_ccid pa_bc_packets.budget_ccid%type := null;

Line 2455: FROM dual

2451: AND decode(nvl(AID.cancellation_flag,'N'), 'Y', decode(AID.Parent_Reversal_id, null,'N','Y'),'N') = 'Y';
2452:
2453: CURSOR C_check_main_cancelled_dist IS
2454: SELECT 'Y'
2455: FROM dual
2456: WHERE exists ( select 1
2457: from ap_invoice_distributions_all aid
2458: where aid.invoice_id = p_invoice_id
2459: and aid.Parent_Reversal_id = p_invoice_distribution_id);