APPS.PA_FP_MULTI_CURRENCY_PKG dependencies on PA_RESOURCE_LIST_MEMBERS

Line 179: l_resource_name pa_resource_list_members.alias%TYPE;

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);
183: l_call_closest_flag varchar2(1) := 'F'; -- Added for Bug#5395732

Line 194: ,pa_resource_list_members prl

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
198: AND pt.proj_element_id(+) = pra.task_id