APPS.PA_FP_GEN_BILLING_AMOUNTS dependencies on PA_RESOURCE_LIST_MEMBERS

Line 97: l_resource_name pa_resource_list_members.alias%TYPE;

93: l_pfc_code pa_projects_all.project_currency_code%type;
94: l_project_name pa_projects_all.name%TYPE;
95: l_task_id pa_tasks.task_id%TYPE;
96: l_task_name pa_proj_elements.name%TYPE;
97: l_resource_name pa_resource_list_members.alias%TYPE;
98: BEGIN
99: /* Setting initial values */
100: X_MSG_COUNT := 0;
101: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 122: FROM pa_resource_list_members prlm, pa_Resource_assignments ra

118: ELSE
119: BEGIN
120: SELECT prlm.alias, nvl(ra.task_id,0)
121: INTO l_resource_name, l_task_id
122: FROM pa_resource_list_members prlm, pa_Resource_assignments ra
123: WHERE ra.resource_assignment_id = p_res_asg_id
124: AND ra.resource_list_member_id = prlm.resource_list_member_id;
125: EXCEPTION
126: WHEN OTHERS THEN