DBA Data[Home] [Help]

APPS.PA_FP_SPREAD_AMTS_PKG dependencies on PA_RESOURCE_LIST_MEMBERS

Line 2982: l_resource_name pa_resource_list_members.alias%TYPE;

2978: l_err_msg VARCHAR2(2000);
2979:
2980: l_project_name pa_projects_all.name%TYPE;
2981: l_task_name pa_proj_elements.name%TYPE;
2982: l_resource_name pa_resource_list_members.alias%TYPE;
2983: l_proj_curr_cd pa_projects_all.project_currency_code%TYPE;
2984: l_projfunc_curr_cd pa_projects_all.projfunc_currency_code%TYPE;
2985:
2986: v_spread_amounts spread_table_type;

Line 3228: ,pa_resource_list_members prl

3224: ,pt.name task_name
3225: ,prl.alias resource_name
3226: FROM pa_projects_all ppa
3227: ,pa_proj_elements pt
3228: ,pa_resource_list_members prl
3229: ,pa_resource_assignments pra
3230: WHERE pra.resource_assignment_id = p_resource_assignment_id
3231: AND ppa.project_id = pra.project_id
3232: AND pt.proj_element_id(+) = pra.task_id