DBA Data[Home] [Help]

APPS.PA_FP_PJI_INTG_PKG dependencies on PA_BUDGET_VERSIONS

Line 93: FROM pa_budget_versions pbv

89:
90: CURSOR strVer IS
91: SELECT DECODE(nvl(pbv.wp_version_flag,'N'),'Y',pbv.project_structure_version_id,
92: PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(pbv.project_id)) project_structure_version_id
93: FROM pa_budget_versions pbv
94: WHERE pbv.budget_version_id = p_budget_version_id;
95:
96: CURSOR cur_pjiDetails IS
97: SELECT pbv.budget_version_id

Line 114: ,pa_budget_versions pbv

110: ,ra.rbs_element_id
111: ,ra.resource_class_code
112: ,ra.rate_based_flag
113: FROM pa_projects_all ppa
114: ,pa_budget_versions pbv
115: ,pa_proj_fp_options ppfo
116: ,pa_resource_assignments ra
117: WHERE ppa.project_id = pbv.project_id
118: AND pbv.budget_version_id = ppfo.fin_plan_version_id

Line 687: FROM pa_budget_versions pbv

683:
684: CURSOR strVer IS
685: SELECT DECODE(nvl(pbv.wp_version_flag,'N'),'Y',pbv.project_structure_version_id,
686: PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(pbv.project_id)) project_structure_version_id
687: FROM pa_budget_versions pbv
688: WHERE pbv.budget_version_id = p_budget_version_id;
689:
690:
691: BEGIN

Line 987: ,pa_budget_versions pbv

983: /* bug fix: 3839761--,l_project_structure_id */
984: ,l_wp_version_flag
985: ,l_time_phase_code
986: FROM pa_projects_all ppa
987: ,pa_budget_versions pbv
988: ,pa_proj_fp_options ppfo
989: ,pa_resource_assignments ra
990: WHERE ppa.project_id = pbv.project_id
991: AND pbv.budget_version_id = ppfo.fin_plan_version_id