APPS.PA_FP_CALC_PLAN_PKG dependencies on PA_PROJ_ELEMENTS

Line 23: g_task_name pa_proj_elements.name%TYPE;

19: g_resource_id NUMBER := to_number(null);
20: g_bv_approved_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
21: g_fp_multi_curr_enabled pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
22: g_project_name pa_projects_all.name%TYPE;
23: g_task_name pa_proj_elements.name%TYPE;
24: g_resource_name pa_resource_list_members.alias%TYPE;
25: g_spread_required_flag VARCHAR2(1) := 'N';
26: g_rollup_required_flag VARCHAR2(1) := 'Y';
27: g_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;

Line 8196: FROM pa_proj_elements pt

8192: ---error code cursor---
8193: CURSOR get_line_info (p_resource_assignment_id IN NUMBER) IS
8194: SELECT pt.name task_name
8195: ,prl.alias resource_name
8196: FROM pa_proj_elements pt
8197: ,pa_resource_list_members prl
8198: ,pa_resource_assignments pra
8199: WHERE pra.resource_assignment_id = p_resource_assignment_id
8200: AND pt.proj_element_id(+) = pra.task_id