DBA Data[Home] [Help]

APPS.PA_FP_MULTI_CURRENCY_PKG dependencies on PA_PROJECTS_ALL

Line 177: l_project_name pa_projects_all.name%TYPE;

173: l_stage NUMBER;
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:

Line 192: FROM pa_projects_all ppa

188: CURSOR get_line_info (p_resource_assignment_id IN NUMBER) IS
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

Line 1847: from pa_projects_all

1843: CURSOR get_project_lvl_data IS
1844: select segment1
1845: ,project_currency_code
1846: ,projfunc_currency_code
1847: from pa_projects_all
1848: where project_id = g_project_id;
1849:
1850: CURSOR all_budget_lines IS
1851: select a.rowid