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_PKG dependencies on PA_RESOURCE_LIST_MEMBERS

Line 6035: pa_resource_list_members rlm,

6031: pa_budget_versions pbv,
6032: pa_budget_entry_methods pm,
6033: pa_budgetary_control_options pb,
6034: pa_projects_all pp,
6035: pa_resource_list_members rlm,
6036: PA_RESOURCE_LISTS_ALL_BG list
6037: WHERE pbc.packet_id = p_packet_id
6038: AND pbc.budget_version_id = pbv.budget_version_id
6039: AND pbv.budget_entry_method_code = pm.budget_entry_method_code

Line 6596: FROM pa_resource_list_members pr

6592: ---------------------------------------------------------------------------
6593: CURSOR cur_bud_res_list_id IS
6594: SELECT pr.resource_list_id,
6595: pr.parent_member_id
6596: FROM pa_resource_list_members pr
6597: WHERE pr.resource_list_member_id = p_resource_list_member_id;
6598:
6599: --This cursor picks up the resource list member id at the resource level
6600: -- if the budget is defined at the resource level

Line 6629: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;

6625: l_budget_version_id pa_bc_packets.budget_version_id%TYPE;
6626: l_project_id pa_bc_packets.project_id%TYPE;
6627: l_task_id pa_bc_packets.bud_task_id%TYPE;
6628: l_resource_list_member_id pa_bc_packets.resource_list_member_id%TYPE;
6629: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;
6630: l_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
6631: l_level pa_resource_list_members.member_level%TYPE;
6632: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
6633: l_bud_res_list_member_id pa_bc_packets.bud_resource_list_member_id%TYPE;

Line 6630: l_parent_member_id pa_resource_list_members.parent_member_id%TYPE;

6626: l_project_id pa_bc_packets.project_id%TYPE;
6627: l_task_id pa_bc_packets.bud_task_id%TYPE;
6628: l_resource_list_member_id pa_bc_packets.resource_list_member_id%TYPE;
6629: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;
6630: l_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
6631: l_level pa_resource_list_members.member_level%TYPE;
6632: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
6633: l_bud_res_list_member_id pa_bc_packets.bud_resource_list_member_id%TYPE;
6634: l_parent_resource_id pa_resource_list_members.parent_member_id%TYPE;

Line 6631: l_level pa_resource_list_members.member_level%TYPE;

6627: l_task_id pa_bc_packets.bud_task_id%TYPE;
6628: l_resource_list_member_id pa_bc_packets.resource_list_member_id%TYPE;
6629: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;
6630: l_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
6631: l_level pa_resource_list_members.member_level%TYPE;
6632: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
6633: l_bud_res_list_member_id pa_bc_packets.bud_resource_list_member_id%TYPE;
6634: l_parent_resource_id pa_resource_list_members.parent_member_id%TYPE;
6635: BEGIN

Line 6634: l_parent_resource_id pa_resource_list_members.parent_member_id%TYPE;

6630: l_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
6631: l_level pa_resource_list_members.member_level%TYPE;
6632: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
6633: l_bud_res_list_member_id pa_bc_packets.bud_resource_list_member_id%TYPE;
6634: l_parent_resource_id pa_resource_list_members.parent_member_id%TYPE;
6635: BEGIN
6636:
6637: IF g_debug_mode = 'Y' THEN
6638: log_message(p_msg_token1 => 'Inside bud_res_list_id_update api');

Line 6966: from PA_RESOURCE_LIST_MEMBERS rlm

6962: in pa_budgetary_control_options for the resource group/resource is "Default from Resource List"
6963: then the funds control levels are derived appropriately from the resource list. */
6964: CURSOR c_res_resgrp_no_bc (c_resource_list_member_id NUMBER) IS
6965: select nvl(rlm.funds_control_level_code,'N')
6966: from PA_RESOURCE_LIST_MEMBERS rlm
6967: where rlm.resource_list_member_id = c_resource_list_member_id
6968: and rlm.ENABLED_FLAG = 'Y'
6969: and DECODE(rlm.RESOURCE_TYPE_CODE, 'UNCLASSIFIED', 'Y', DISPLAY_FLAG) = 'Y'
6970: and nvl(rlm.migration_code, 'M') = 'M';

Line 14975: pa_resource_list_members prlm

14971: nvl(prlm.parent_member_id,-99) parent_rlmi
14972: from gl_bc_packets glbc,
14973: pa_budget_lines pbl,
14974: pa_resource_assignments pra,
14975: pa_resource_list_members prlm
14976: where glbc.packet_id = p_packet_id
14977: and pbl.budget_version_id = p_budget_version_id
14978: and pbl.budget_line_id = glbc.source_distribution_id_num_1
14979: and pra.resource_assignment_id = pbl.resource_assignment_id