DBA Data[Home] [Help]

APPS.PA_FP_SPREAD_AMTS_PKG dependencies on PA_RESOURCE_LIST_MEMBERS

Line 2252: l_resource_name pa_resource_list_members.alias%TYPE;

2248: l_err_msg VARCHAR2(2000);
2249:
2250: l_project_name pa_projects_all.name%TYPE;
2251: l_task_name pa_proj_elements.name%TYPE;
2252: l_resource_name pa_resource_list_members.alias%TYPE;
2253: l_proj_curr_cd pa_projects_all.project_currency_code%TYPE;
2254: l_projfunc_curr_cd pa_projects_all.projfunc_currency_code%TYPE;
2255:
2256: v_spread_amounts spread_table_type;

Line 2498: ,pa_resource_list_members prl

2494: ,pt.name task_name
2495: ,prl.alias resource_name
2496: FROM pa_projects_all ppa
2497: ,pa_proj_elements pt
2498: ,pa_resource_list_members prl
2499: ,pa_resource_assignments pra
2500: WHERE pra.resource_assignment_id = p_resource_assignment_id
2501: AND ppa.project_id = pra.project_id
2502: AND pt.proj_element_id(+) = pra.task_id