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 762: from pa_resource_assignments pra,

758: END IF;
759:
760: select pbl.code_combination_id, pbl.budget_line_id
761: into x_budget_ccid, x_budget_line_id
762: from pa_resource_assignments pra,
763: pa_budget_lines pbl
764: where ((p_entry_level_code = 'P' and
765: pra.task_id = 0)
766: or

Line 1009: l_rlmi pa_resource_assignments.resource_list_member_id%type;

1005: l_return_status varchar2(1);
1006: l_budget_entry_level_code pa_budget_entry_methods.entry_level_code%type;
1007: l_period_name pa_budget_lines.period_name%type;
1008: l_start_date pa_budget_lines.start_date%type;
1009: l_rlmi pa_resource_assignments.resource_list_member_id%type;
1010: l_task_id pa_resource_assignments.task_id%type;
1011:
1012: Begin
1013: l_return_status := 'N';

Line 1010: l_task_id pa_resource_assignments.task_id%type;

1006: l_budget_entry_level_code pa_budget_entry_methods.entry_level_code%type;
1007: l_period_name pa_budget_lines.period_name%type;
1008: l_start_date pa_budget_lines.start_date%type;
1009: l_rlmi pa_resource_assignments.resource_list_member_id%type;
1010: l_task_id pa_resource_assignments.task_id%type;
1011:
1012: Begin
1013: l_return_status := 'N';
1014: l_budget_entry_level_code := P_budget_entry_level_code;

Line 1148: from pa_resource_assignments pra,

1144:
1145: Begin
1146: Select 'T'
1147: into l_budget_entry_level_code
1148: from pa_resource_assignments pra,
1149: pa_tasks pt
1150: where pra.resource_assignment_id = P_resource_assignment_id
1151: and pra.budget_version_id = P_budget_version_id
1152: and pt.task_id = pra.task_id

Line 1172: from pa_resource_assignments pra

1168: END IF;
1169:
1170: select task_id,resource_list_member_id
1171: into l_task_id,l_rlmi
1172: from pa_resource_assignments pra
1173: where pra.resource_assignment_id = P_resource_assignment_id;
1174:
1175: IF P_DEBUG_MODE = 'Y' THEN
1176: pa_fck_util.debug_msg('Is_account_change_allowed: get parent rlmi');

Line 1260: from pa_resource_assignments pra

1256: Begin -- 'L' : pa_bc_packets
1257:
1258: Select 'N'
1259: into l_return_status
1260: from pa_resource_assignments pra
1261: where pra.budget_version_id = p_budget_version_id
1262: and pra.resource_assignment_id = p_resource_assignment_id
1263: and exists(select 1
1264: from pa_bc_packets pbc

Line 1274: from pa_resource_assignments pra

1270: When no_data_found then
1271: Begin -- 'L' : pa_bc_commitments_all
1272: Select 'N'
1273: into l_return_status
1274: from pa_resource_assignments pra
1275: where pra.budget_version_id = p_budget_version_id
1276: and pra.resource_assignment_id = p_resource_assignment_id
1277: and exists(select 1
1278: from pa_bc_commitments_all pbc

Line 1295: from pa_resource_assignments pra,

1291: Begin -- 'L' : pa_bc_balances
1292:
1293: Select 'N'
1294: into l_return_status
1295: from pa_resource_assignments pra,
1296: pa_budget_lines pbl
1297: where pbl.budget_version_id = p_budget_version_id
1298: and pbl.resource_assignment_id = p_resource_assignment_id
1299: and pbl.period_name = P_period_name

Line 1318: from pa_resource_assignments pra

1314: Begin -- 'L' : pa_bc_packets
1315:
1316: Select 'N'
1317: into l_return_status
1318: from pa_resource_assignments pra
1319: where pra.budget_version_id = p_budget_version_id
1320: and pra.resource_assignment_id = p_resource_assignment_id
1321: and exists(select 1
1322: from pa_bc_packets pbc

Line 1347: from pa_resource_assignments pra

1343: Begin -- 'T' : pa_bc_packets
1344:
1345: Select 'N'
1346: into l_return_status
1347: from pa_resource_assignments pra
1348: where pra.budget_version_id = p_budget_version_id
1349: and pra.resource_assignment_id = p_resource_assignment_id
1350: and exists(select 1
1351: from pa_bc_packets pbc

Line 1361: from pa_resource_assignments pra

1357: When no_data_found then
1358: Begin -- 'T' : pa_bc_commitments_all
1359: Select 'N'
1360: into l_return_status
1361: from pa_resource_assignments pra
1362: where pra.budget_version_id = p_budget_version_id
1363: and pra.resource_assignment_id = p_resource_assignment_id
1364: and exists(select 1
1365: from pa_bc_commitments_all pbc

Line 1383: from pa_resource_assignments pra,

1379: Begin -- 'T' : pa_bc_balances
1380:
1381: Select 'N'
1382: into l_return_status
1383: from pa_resource_assignments pra,
1384: pa_budget_lines pbl
1385: where pbl.budget_version_id = p_budget_version_id
1386: and pbl.resource_assignment_id = p_resource_assignment_id
1387: and pbl.period_name = P_period_name

Line 1405: from pa_resource_assignments pra

1401: Begin -- 'T' : pa_bc_packets
1402:
1403: Select 'N'
1404: into l_return_status
1405: from pa_resource_assignments pra
1406: where pra.budget_version_id = p_budget_version_id
1407: and pra.resource_assignment_id = p_resource_assignment_id
1408: and exists(select 1
1409: from pa_bc_packets pbc

Line 1434: from pa_resource_assignments pra

1430: Begin -- 'P' : pa_bc_packets
1431:
1432: Select 'N'
1433: into l_return_status
1434: from pa_resource_assignments pra
1435: where pra.budget_version_id = p_budget_version_id
1436: and pra.resource_assignment_id = p_resource_assignment_id
1437: and exists(select 1
1438: from pa_bc_packets pbc

Line 1447: from pa_resource_assignments pra

1443: When no_data_found then
1444: Begin -- 'P' : pa_bc_commitments_all
1445: Select 'N'
1446: into l_return_status
1447: from pa_resource_assignments pra
1448: where pra.budget_version_id = p_budget_version_id
1449: and pra.resource_assignment_id = p_resource_assignment_id
1450: and exists(select 1
1451: from pa_bc_commitments_all pbc

Line 1468: from pa_resource_assignments pra,

1464: Begin -- 'P' : pa_bc_balances
1465:
1466: Select 'N'
1467: into l_return_status
1468: from pa_resource_assignments pra,
1469: pa_budget_lines pbl
1470: where pbl.budget_version_id = p_budget_version_id
1471: and pbl.resource_assignment_id = p_resource_assignment_id
1472: and pbl.period_name = P_period_name

Line 1490: from pa_resource_assignments pra

1486: Begin -- 'P' : pa_bc_packets
1487:
1488: Select 'N'
1489: into l_return_status
1490: from pa_resource_assignments pra
1491: where pra.budget_version_id = p_budget_version_id
1492: and pra.resource_assignment_id = p_resource_assignment_id
1493: and exists(select 1
1494: from pa_bc_packets pbc

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

1541: l_allowed_flag := 'Y';
1542:
1543: -- # Determine entry level code if its 'M'.
1544: If p_entry_level_code = 'M' then
1545: -- task_id being passed is that on pa_resource_assignments ...
1546: -- top task id is determined from pa_tasks
1547: If p_task_id = p_top_task_id then
1548: l_budget_entry_level_code := 'T';
1549: Else