APPS.PA_FIN_PLAN_UTILS2 dependencies on PA_PROJECTS_ALL

Line 575: ,pa_projects_all pp

571: ,3 Default_level
572: ,rla.resource_list_id
573: from pa_resource_list_assignments rla
574: ,pa_resource_list_uses rlu
575: ,pa_projects_all pp
576: where pp.project_id = p_project_id
577: and rla.project_id = pp.project_id
578: and rlu.resource_list_assignment_id = rla.resource_list_assignment_id
579: and rlu.default_flag = 'Y'

Line 2695: FROM pa_projects_all pp

2691: ,pp.non_labor_sch_type
2692: ,to_number(null) project_structure_version_id
2693: ,pp.project_id
2694: ,pp.segment1 project_name
2695: FROM pa_projects_all pp
2696: WHERE pp.project_id = p_project_id;
2697:
2698: CURSOR CUR_VersionDts IS
2699: SELECT decode(nvl(pfo.use_planning_rates_flag,'N'),'N',pfo.res_class_bill_rate_sch_id,

Line 2765: ,pa_projects_all pp

2761: ,bv.project_id
2762: ,pp.segment1 project_name
2763: FROM pa_proj_fp_options pfo
2764: ,pa_budget_versions bv
2765: ,pa_projects_all pp
2766: WHERE pfo.fin_plan_version_id = bv.budget_version_id
2767: AND bv.budget_version_id = p_budget_version_id
2768: AND pp.project_id = bv.project_id
2769: AND pfo.project_id = pp.project_id;

Line 2866: l_labor_sch_type pa_projects_all.labor_sch_type%TYPE;

2862: l_mfc_cost_source CONSTANT NUMBER := 2;
2863: x_stage varchar2(1000);
2864: l_status varchar2(100);
2865:
2866: l_labor_sch_type pa_projects_all.labor_sch_type%TYPE;
2867: l_non_labor_sch_type pa_projects_all.labor_sch_type%TYPE;
2868:
2869: /* Added these variables for bug fix: 3681314,3828998 */
2870: l_override_organization_id Number;

Line 2867: l_non_labor_sch_type pa_projects_all.labor_sch_type%TYPE;

2863: x_stage varchar2(1000);
2864: l_status varchar2(100);
2865:
2866: l_labor_sch_type pa_projects_all.labor_sch_type%TYPE;
2867: l_non_labor_sch_type pa_projects_all.labor_sch_type%TYPE;
2868:
2869: /* Added these variables for bug fix: 3681314,3828998 */
2870: l_override_organization_id Number;
2871: l_debug_flag Varchar2(1) := 'N';