APPS.PA_FP_GEN_COMMITMENT_AMOUNTS dependencies on PA_RESOURCE_LIST_MEMBERS

Line 283: l_resource_name PA_RESOURCE_LIST_MEMBERS.ALIAS%TYPE;

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

Line 905: pa_resource_list_members rlm

901: INTO l_project_name, l_task_number, l_resource_name
902: FROM pa_resource_assignments ra,
903: pa_projects_all p,
904: pa_tasks ta,
905: pa_resource_list_members rlm
906: WHERE ra.resource_assignment_id = l_res_asg_id(i)
907: AND p.project_id = ra.project_id
908: AND ta.task_id (+) = ra.task_id
909: AND rlm.resource_list_member_id = ra.resource_list_member_id;