APPS.PA_FP_MULTI_CURRENCY_PKG dependencies on PA_PROJ_ELEMENTS

Line 178: l_task_name pa_proj_elements.name%TYPE;

174: l_debug_mode VARCHAR2(30);
175: l_number NUMBER;
176:
177: l_project_name pa_projects_all.name%TYPE;
178: l_task_name pa_proj_elements.name%TYPE;
179: l_resource_name pa_resource_list_members.alias%TYPE;
180: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
181:
182: l_allow_user_rate_type VARCHAR2(1);

Line 193: ,pa_proj_elements pt

189: SELECT ppa.name project_name
190: ,pt.name task_name
191: ,prl.alias resource_name
192: FROM pa_projects_all ppa
193: ,pa_proj_elements pt
194: ,pa_resource_list_members prl
195: ,pa_resource_assignments pra
196: WHERE pra.resource_assignment_id = p_resource_assignment_id
197: AND ppa.project_id = pra.project_id