DBA Data[Home] [Help]

APPS.PA_FP_SPREAD_AMTS_PKG dependencies on PA_PROJ_ELEMENTS

Line 2251: l_task_name pa_proj_elements.name%TYPE;

2247:
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:

Line 2497: ,pa_proj_elements pt

2493: SELECT ppa.name project_name
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