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 2688: FROM pa_projects_all pp

2684: ,pp.non_labor_sch_type
2685: ,to_number(null) project_structure_version_id
2686: ,pp.project_id
2687: ,pp.segment1 project_name
2688: FROM pa_projects_all pp
2689: WHERE pp.project_id = p_project_id;
2690:
2691: CURSOR CUR_VersionDts IS
2692: SELECT decode(nvl(pfo.use_planning_rates_flag,'N'),'N',pfo.res_class_bill_rate_sch_id,

Line 2758: ,pa_projects_all pp

2754: ,bv.project_id
2755: ,pp.segment1 project_name
2756: FROM pa_proj_fp_options pfo
2757: ,pa_budget_versions bv
2758: ,pa_projects_all pp
2759: WHERE pfo.fin_plan_version_id = bv.budget_version_id
2760: AND bv.budget_version_id = p_budget_version_id
2761: AND pp.project_id = bv.project_id
2762: AND pfo.project_id = pp.project_id;

Line 2859: l_labor_sch_type pa_projects_all.labor_sch_type%TYPE;

2855: l_mfc_cost_source CONSTANT NUMBER := 2;
2856: x_stage varchar2(1000);
2857: l_status varchar2(100);
2858:
2859: l_labor_sch_type pa_projects_all.labor_sch_type%TYPE;
2860: l_non_labor_sch_type pa_projects_all.labor_sch_type%TYPE;
2861:
2862: /* Added these variables for bug fix: 3681314,3828998 */
2863: l_override_organization_id Number;

Line 2860: l_non_labor_sch_type pa_projects_all.labor_sch_type%TYPE;

2856: x_stage varchar2(1000);
2857: l_status varchar2(100);
2858:
2859: l_labor_sch_type pa_projects_all.labor_sch_type%TYPE;
2860: l_non_labor_sch_type pa_projects_all.labor_sch_type%TYPE;
2861:
2862: /* Added these variables for bug fix: 3681314,3828998 */
2863: l_override_organization_id Number;
2864: l_debug_flag Varchar2(1) := 'N';