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 8035: ,pa_resource_list_members rl

8031: ,ra.sp_fixed_date
8032: ,ra.rate_based_flag
8033: ,rl.alias Resource_Name
8034: FROM pa_resource_assignments ra
8035: ,pa_resource_list_members rl
8036: WHERE ra.resource_assignment_id = p_resource_asg_id
8037: AND ra.resource_list_member_id = rl.resource_list_member_id ;
8038: ResAsgnRec get_resource_asn_csr%ROWTYPE;
8039:

Line 8077: ,pa_resource_list_members rl

8073: -- End for 6781055
8074: FROM pa_fp_rollup_tmp tmp
8075: ,pa_budget_versions bv
8076: ,pa_resource_assignments ra
8077: ,pa_resource_list_members rl
8078: WHERE bv.budget_version_id = p_budget_version_id
8079: AND ra.budget_version_id = bv.budget_version_id
8080: AND tmp.resource_assignment_id = ra.resource_assignment_id
8081: AND ra.resource_list_member_id = rl.resource_list_member_id

Line 8092: ,pa_resource_list_members prl

8088: CURSOR get_line_info (p_resource_assignment_id IN NUMBER) IS
8089: SELECT pt.name task_name
8090: ,prl.alias resource_name
8091: FROM pa_proj_elements pt
8092: ,pa_resource_list_members prl
8093: ,pa_resource_assignments pra
8094: WHERE pra.resource_assignment_id = p_resource_assignment_id
8095: AND pt.proj_element_id(+) = pra.task_id
8096: AND prl.resource_list_member_id = pra.resource_list_member_id;

Line 11665: ,pa_resource_list_members rl

11661: ,tmp.bill_markup_percentage
11662: ,NVL(tmp.system_reference6,'Y') markup_calculation_flag
11663: FROM pa_resource_assignments ra
11664: ,pa_fp_rollup_tmp tmp
11665: ,pa_resource_list_members rl
11666: WHERE tmp.resource_assignment_id = p_resource_assignment_id
11667: AND ra.resource_assignment_id = tmp.resource_assignment_id
11668: AND rl.resource_list_member_id = ra.resource_list_member_id
11669: AND tmp.txn_currency_code = decode(p_txn_curr_code_Ovr,NULL,p_txn_currency_code