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 PA_RESOURCE_ASSIGNMENTS

Line 913: from pa_resource_assignments pra,

909: END IF;
910:
911: select pbl.code_combination_id, pbl.budget_line_id
912: into x_budget_ccid, x_budget_line_id
913: from pa_resource_assignments pra,
914: pa_budget_lines pbl
915: where ((p_entry_level_code = 'P' and
916: pra.task_id = 0)
917: or

Line 1160: l_rlmi pa_resource_assignments.resource_list_member_id%type;

1156: l_return_status varchar2(1);
1157: l_budget_entry_level_code pa_budget_entry_methods.entry_level_code%type;
1158: l_period_name pa_budget_lines.period_name%type;
1159: l_start_date pa_budget_lines.start_date%type;
1160: l_rlmi pa_resource_assignments.resource_list_member_id%type;
1161: l_task_id pa_resource_assignments.task_id%type;
1162:
1163: Begin
1164: l_return_status := 'N';

Line 1161: l_task_id pa_resource_assignments.task_id%type;

1157: l_budget_entry_level_code pa_budget_entry_methods.entry_level_code%type;
1158: l_period_name pa_budget_lines.period_name%type;
1159: l_start_date pa_budget_lines.start_date%type;
1160: l_rlmi pa_resource_assignments.resource_list_member_id%type;
1161: l_task_id pa_resource_assignments.task_id%type;
1162:
1163: Begin
1164: l_return_status := 'N';
1165: l_budget_entry_level_code := P_budget_entry_level_code;

Line 1299: from pa_resource_assignments pra,

1295:
1296: Begin
1297: Select 'T'
1298: into l_budget_entry_level_code
1299: from pa_resource_assignments pra,
1300: pa_tasks pt
1301: where pra.resource_assignment_id = P_resource_assignment_id
1302: and pra.budget_version_id = P_budget_version_id
1303: and pt.task_id = pra.task_id

Line 1323: from pa_resource_assignments pra

1319: END IF;
1320:
1321: select task_id,resource_list_member_id
1322: into l_task_id,l_rlmi
1323: from pa_resource_assignments pra
1324: where pra.resource_assignment_id = P_resource_assignment_id;
1325:
1326: IF P_DEBUG_MODE = 'Y' THEN
1327: pa_fck_util.debug_msg('Is_account_change_allowed: get parent rlmi');

Line 1411: from pa_resource_assignments pra

1407: Begin -- 'L' : pa_bc_packets
1408:
1409: Select 'N'
1410: into l_return_status
1411: from pa_resource_assignments pra
1412: where pra.budget_version_id = p_budget_version_id
1413: and pra.resource_assignment_id = p_resource_assignment_id
1414: and exists(select 1
1415: from pa_bc_packets pbc

Line 1425: from pa_resource_assignments pra

1421: When no_data_found then
1422: Begin -- 'L' : pa_bc_commitments_all
1423: Select 'N'
1424: into l_return_status
1425: from pa_resource_assignments pra
1426: where pra.budget_version_id = p_budget_version_id
1427: and pra.resource_assignment_id = p_resource_assignment_id
1428: and exists(select 1
1429: from pa_bc_commitments_all pbc

Line 1446: from pa_resource_assignments pra,

1442: Begin -- 'L' : pa_bc_balances
1443:
1444: Select 'N'
1445: into l_return_status
1446: from pa_resource_assignments pra,
1447: pa_budget_lines pbl
1448: where pbl.budget_version_id = p_budget_version_id
1449: and pbl.resource_assignment_id = p_resource_assignment_id
1450: and pbl.period_name = P_period_name

Line 1469: from pa_resource_assignments pra

1465: Begin -- 'L' : pa_bc_packets
1466:
1467: Select 'N'
1468: into l_return_status
1469: from pa_resource_assignments pra
1470: where pra.budget_version_id = p_budget_version_id
1471: and pra.resource_assignment_id = p_resource_assignment_id
1472: and exists(select 1
1473: from pa_bc_packets pbc

Line 1498: from pa_resource_assignments pra

1494: Begin -- 'T' : pa_bc_packets
1495:
1496: Select 'N'
1497: into l_return_status
1498: from pa_resource_assignments pra
1499: where pra.budget_version_id = p_budget_version_id
1500: and pra.resource_assignment_id = p_resource_assignment_id
1501: and exists(select 1
1502: from pa_bc_packets pbc

Line 1512: from pa_resource_assignments pra

1508: When no_data_found then
1509: Begin -- 'T' : pa_bc_commitments_all
1510: Select 'N'
1511: into l_return_status
1512: from pa_resource_assignments pra
1513: where pra.budget_version_id = p_budget_version_id
1514: and pra.resource_assignment_id = p_resource_assignment_id
1515: and exists(select 1
1516: from pa_bc_commitments_all pbc

Line 1534: from pa_resource_assignments pra,

1530: Begin -- 'T' : pa_bc_balances
1531:
1532: Select 'N'
1533: into l_return_status
1534: from pa_resource_assignments pra,
1535: pa_budget_lines pbl
1536: where pbl.budget_version_id = p_budget_version_id
1537: and pbl.resource_assignment_id = p_resource_assignment_id
1538: and pbl.period_name = P_period_name

Line 1556: from pa_resource_assignments pra

1552: Begin -- 'T' : pa_bc_packets
1553:
1554: Select 'N'
1555: into l_return_status
1556: from pa_resource_assignments pra
1557: where pra.budget_version_id = p_budget_version_id
1558: and pra.resource_assignment_id = p_resource_assignment_id
1559: and exists(select 1
1560: from pa_bc_packets pbc

Line 1585: from pa_resource_assignments pra

1581: Begin -- 'P' : pa_bc_packets
1582:
1583: Select 'N'
1584: into l_return_status
1585: from pa_resource_assignments pra
1586: where pra.budget_version_id = p_budget_version_id
1587: and pra.resource_assignment_id = p_resource_assignment_id
1588: and exists(select 1
1589: from pa_bc_packets pbc

Line 1598: from pa_resource_assignments pra

1594: When no_data_found then
1595: Begin -- 'P' : pa_bc_commitments_all
1596: Select 'N'
1597: into l_return_status
1598: from pa_resource_assignments pra
1599: where pra.budget_version_id = p_budget_version_id
1600: and pra.resource_assignment_id = p_resource_assignment_id
1601: and exists(select 1
1602: from pa_bc_commitments_all pbc

Line 1619: from pa_resource_assignments pra,

1615: Begin -- 'P' : pa_bc_balances
1616:
1617: Select 'N'
1618: into l_return_status
1619: from pa_resource_assignments pra,
1620: pa_budget_lines pbl
1621: where pbl.budget_version_id = p_budget_version_id
1622: and pbl.resource_assignment_id = p_resource_assignment_id
1623: and pbl.period_name = P_period_name

Line 1641: from pa_resource_assignments pra

1637: Begin -- 'P' : pa_bc_packets
1638:
1639: Select 'N'
1640: into l_return_status
1641: from pa_resource_assignments pra
1642: where pra.budget_version_id = p_budget_version_id
1643: and pra.resource_assignment_id = p_resource_assignment_id
1644: and exists(select 1
1645: from pa_bc_packets pbc

Line 1696: -- task_id being passed is that on pa_resource_assignments ...

1692: l_allowed_flag := 'Y';
1693:
1694: -- # Determine entry level code if its 'M'.
1695: If p_entry_level_code = 'M' then
1696: -- task_id being passed is that on pa_resource_assignments ...
1697: -- top task id is determined from pa_tasks
1698: If p_task_id = p_top_task_id then
1699: l_budget_entry_level_code := 'T';
1700: Else