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 115: ,pa_budget_versions pbv

111: ,ra.cbs_element_id --bug#16200605
112: ,ra.resource_class_code
113: ,ra.rate_based_flag
114: FROM pa_projects_all ppa
115: ,pa_budget_versions pbv
116: ,pa_proj_fp_options ppfo
117: ,pa_resource_assignments ra
118: WHERE ppa.project_id = pbv.project_id
119: AND pbv.budget_version_id = ppfo.fin_plan_version_id

Line 692: FROM pa_budget_versions pbv

688:
689: CURSOR strVer IS
690: SELECT DECODE(nvl(pbv.wp_version_flag,'N'),'Y',pbv.project_structure_version_id,
691: PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(pbv.project_id)) project_structure_version_id
692: FROM pa_budget_versions pbv
693: WHERE pbv.budget_version_id = p_budget_version_id;
694:
695:
696: BEGIN

Line 995: ,pa_budget_versions pbv

991: /* bug fix: 3839761--,l_project_structure_id */
992: ,l_wp_version_flag
993: ,l_time_phase_code
994: FROM pa_projects_all ppa
995: ,pa_budget_versions pbv
996: ,pa_proj_fp_options ppfo
997: ,pa_resource_assignments ra
998: WHERE ppa.project_id = pbv.project_id
999: AND pbv.budget_version_id = ppfo.fin_plan_version_id