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 5892: pa_resource_list_members rlm,

5888: pa_budget_versions pbv,
5889: pa_budget_entry_methods pm,
5890: pa_budgetary_control_options pb,
5891: pa_projects_all pp,
5892: pa_resource_list_members rlm,
5893: PA_RESOURCE_LISTS_ALL_BG list
5894: WHERE pbc.packet_id = p_packet_id
5895: AND pbc.budget_version_id = pbv.budget_version_id
5896: AND pbv.budget_entry_method_code = pm.budget_entry_method_code

Line 6444: FROM pa_resource_list_members pr

6440: ---------------------------------------------------------------------------
6441: CURSOR cur_bud_res_list_id IS
6442: SELECT pr.resource_list_id,
6443: pr.parent_member_id
6444: FROM pa_resource_list_members pr
6445: WHERE pr.resource_list_member_id = p_resource_list_member_id;
6446:
6447: --This cursor picks up the resource list member id at the resource level
6448: -- if the budget is defined at the resource level

Line 6477: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;

6473: l_budget_version_id pa_bc_packets.budget_version_id%TYPE;
6474: l_project_id pa_bc_packets.project_id%TYPE;
6475: l_task_id pa_bc_packets.bud_task_id%TYPE;
6476: l_resource_list_member_id pa_bc_packets.resource_list_member_id%TYPE;
6477: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;
6478: l_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
6479: l_level pa_resource_list_members.member_level%TYPE;
6480: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
6481: l_bud_res_list_member_id pa_bc_packets.bud_resource_list_member_id%TYPE;

Line 6478: l_parent_member_id pa_resource_list_members.parent_member_id%TYPE;

6474: l_project_id pa_bc_packets.project_id%TYPE;
6475: l_task_id pa_bc_packets.bud_task_id%TYPE;
6476: l_resource_list_member_id pa_bc_packets.resource_list_member_id%TYPE;
6477: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;
6478: l_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
6479: l_level pa_resource_list_members.member_level%TYPE;
6480: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
6481: l_bud_res_list_member_id pa_bc_packets.bud_resource_list_member_id%TYPE;
6482: l_parent_resource_id pa_resource_list_members.parent_member_id%TYPE;

Line 6479: l_level pa_resource_list_members.member_level%TYPE;

6475: l_task_id pa_bc_packets.bud_task_id%TYPE;
6476: l_resource_list_member_id pa_bc_packets.resource_list_member_id%TYPE;
6477: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;
6478: l_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
6479: l_level pa_resource_list_members.member_level%TYPE;
6480: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
6481: l_bud_res_list_member_id pa_bc_packets.bud_resource_list_member_id%TYPE;
6482: l_parent_resource_id pa_resource_list_members.parent_member_id%TYPE;
6483: BEGIN

Line 6482: l_parent_resource_id pa_resource_list_members.parent_member_id%TYPE;

6478: l_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
6479: l_level pa_resource_list_members.member_level%TYPE;
6480: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
6481: l_bud_res_list_member_id pa_bc_packets.bud_resource_list_member_id%TYPE;
6482: l_parent_resource_id pa_resource_list_members.parent_member_id%TYPE;
6483: BEGIN
6484:
6485: OPEN cur_bud_res_list_id;
6486: LOOP

Line 6799: from PA_RESOURCE_LIST_MEMBERS rlm

6795: in pa_budgetary_control_options for the resource group/resource is "Default from Resource List"
6796: then the funds control levels are derived appropriately from the resource list. */
6797: CURSOR c_res_resgrp_no_bc (c_resource_list_member_id NUMBER) IS
6798: select nvl(rlm.funds_control_level_code,'N')
6799: from PA_RESOURCE_LIST_MEMBERS rlm
6800: where rlm.resource_list_member_id = c_resource_list_member_id
6801: and rlm.ENABLED_FLAG = 'Y'
6802: and DECODE(rlm.RESOURCE_TYPE_CODE, 'UNCLASSIFIED', 'Y', DISPLAY_FLAG) = 'Y'
6803: and nvl(rlm.migration_code, 'M') = 'M';

Line 14553: pa_resource_list_members prlm

14549: nvl(prlm.parent_member_id,-99) parent_rlmi
14550: from gl_bc_packets glbc,
14551: pa_budget_lines pbl,
14552: pa_resource_assignments pra,
14553: pa_resource_list_members prlm
14554: where glbc.packet_id = p_packet_id
14555: and pbl.budget_version_id = p_budget_version_id
14556: and pbl.budget_line_id = glbc.source_distribution_id_num_1
14557: and pra.resource_assignment_id = pbl.resource_assignment_id