APPS.PA_FP_CALC_PLAN_PKG dependencies on PA_RESOURCE_LIST_MEMBERS

Line 24: g_resource_name pa_resource_list_members.alias%TYPE;

20: g_bv_approved_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
21: g_fp_multi_curr_enabled pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
22: g_project_name pa_projects_all.name%TYPE;
23: g_task_name pa_proj_elements.name%TYPE;
24: g_resource_name pa_resource_list_members.alias%TYPE;
25: g_spread_required_flag VARCHAR2(1) := 'N';
26: g_rollup_required_flag VARCHAR2(1) := 'Y';
27: g_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;
28: g_proj_structure_ver_id NUMBER;

Line 8140: ,pa_resource_list_members rl

8136: ,ra.sp_fixed_date
8137: ,ra.rate_based_flag
8138: ,rl.alias Resource_Name
8139: FROM pa_resource_assignments ra
8140: ,pa_resource_list_members rl
8141: WHERE ra.resource_assignment_id = p_resource_asg_id
8142: AND ra.resource_list_member_id = rl.resource_list_member_id ;
8143: ResAsgnRec get_resource_asn_csr%ROWTYPE;
8144:

Line 8182: ,pa_resource_list_members rl

8178: -- End for 6781055
8179: FROM pa_fp_rollup_tmp tmp
8180: ,pa_budget_versions bv
8181: ,pa_resource_assignments ra
8182: ,pa_resource_list_members rl
8183: WHERE bv.budget_version_id = p_budget_version_id
8184: AND ra.budget_version_id = bv.budget_version_id
8185: AND tmp.resource_assignment_id = ra.resource_assignment_id
8186: AND ra.resource_list_member_id = rl.resource_list_member_id

Line 8197: ,pa_resource_list_members prl

8193: CURSOR get_line_info (p_resource_assignment_id IN NUMBER) IS
8194: SELECT pt.name task_name
8195: ,prl.alias resource_name
8196: FROM pa_proj_elements pt
8197: ,pa_resource_list_members prl
8198: ,pa_resource_assignments pra
8199: WHERE pra.resource_assignment_id = p_resource_assignment_id
8200: AND pt.proj_element_id(+) = pra.task_id
8201: AND prl.resource_list_member_id = pra.resource_list_member_id;

Line 11845: ,pa_resource_list_members rl

11841: ,tmp.bill_markup_percentage
11842: ,NVL(tmp.system_reference6,'Y') markup_calculation_flag
11843: FROM pa_resource_assignments ra
11844: ,pa_fp_rollup_tmp tmp
11845: ,pa_resource_list_members rl
11846: WHERE tmp.resource_assignment_id = p_resource_assignment_id
11847: AND ra.resource_assignment_id = tmp.resource_assignment_id
11848: AND rl.resource_list_member_id = ra.resource_list_member_id
11849: AND tmp.txn_currency_code = decode(p_txn_curr_code_Ovr,NULL,p_txn_currency_code