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 8091: FROM pa_proj_elements pt

8087: ---error code cursor---
8088: CURSOR get_line_info (p_resource_assignment_id IN NUMBER) IS
8089: SELECT pt.name task_name
8090: ,prl.alias resource_name
8091: FROM pa_proj_elements pt
8092: ,pa_resource_list_members prl
8093: ,pa_resource_assignments pra
8094: WHERE pra.resource_assignment_id = p_resource_assignment_id
8095: AND pt.proj_element_id(+) = pra.task_id