APPS.PA_FP_GEN_COMMITMENT_AMOUNTS dependencies on PA_RESOURCE_LIST_MEMBERS

Line 282: l_resource_name PA_RESOURCE_LIST_MEMBERS.ALIAS%TYPE;

278: l_pfc_cur_conv_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
279:
280: l_project_name PA_PROJECTS_ALL.NAME%TYPE;
281: l_task_number PA_TASKS.TASK_NUMBER%TYPE;
282: l_resource_name PA_RESOURCE_LIST_MEMBERS.ALIAS%TYPE;
283:
284: -- Variables added for Bug Fix 4582616
285: l_fp_src_plan_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
286: l_fp_cols_rec_src_finplan PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

Line 897: pa_resource_list_members rlm

893: INTO l_project_name, l_task_number, l_resource_name
894: FROM pa_resource_assignments ra,
895: pa_projects_all p,
896: pa_tasks ta,
897: pa_resource_list_members rlm
898: WHERE ra.resource_assignment_id = l_res_asg_id(i)
899: AND p.project_id = ra.project_id
900: AND ta.task_id (+) = ra.task_id
901: AND rlm.resource_list_member_id = ra.resource_list_member_id;