DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_UTILS2 dependencies on PA_PROJ_FP_OPTIONS

Line 548: from pa_proj_fp_options fp

544: CURSOR cur_projReslist IS
545: select fp.project_id
546: ,1 default_level --just for ordering purpose
547: ,NVL(fp.cost_resource_list_id,fp.all_resource_list_id) Resource_list_id
548: from pa_proj_fp_options fp
549: ,pa_fin_plan_types_b typ
550: where fp.project_id = p_project_id
551: and fp.fin_plan_type_id = typ.fin_plan_type_id
552: and typ.plan_class_code = 'BUDGET'

Line 2756: FROM pa_proj_fp_options pfo

2752: ,pp.non_labor_sch_type
2753: ,bv.project_structure_version_id
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