APPS.PA_FP_GEN_AMT_WRP_PKG dependencies on PA_BUDGET_VERSIONS

Line 102: l_version_type pa_budget_versions.version_type%TYPE;

98: -- gboomina added for AAI requirement 8318932 - end
99:
100: --Bug 16181483 Start
101: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
102: l_version_type pa_budget_versions.version_type%TYPE;
103: --Bug 16181483 End
104:
105: BEGIN
106: -- hr_utility.trace_on(null,'Sharmila');

Line 684: from pa_budget_versions

680: --hr_utility.trace('fp cols rec gen src wp version id not null '||
681: --l_fp_cols_rec.x_gen_src_wp_version_id );
682: l_etc_wp_fin_ver_id := l_fp_cols_rec.x_gen_src_wp_version_id;
683: select project_structure_version_id into l_etc_wp_struct_ver_id
684: from pa_budget_versions
685: where budget_version_id = l_etc_wp_fin_ver_id;
686:
687: END IF;
688:

Line 865: FROM pa_budget_versions

861: p_msg_name => 'PA_SRC_FP_VER_NULL');
862: l_gen_api_call_flag := 'N';
863: ELSE
864: SELECT version_name INTO l_etc_fp_ver_name
865: FROM pa_budget_versions
866: WHERE budget_version_id = l_etc_fp_ver_id;
867:
868: l_etc_fp_type_id := l_fp_cols_rec.X_GEN_SRC_PLAN_TYPE_ID;
869: END IF;

Line 948: UPDATE PA_BUDGET_VERSIONS

944: l_struct_sharing_code := PA_PROJECT_STRUCTURE_UTILS.
945: get_structure_sharing_code(p_project_id=>l_proj_id);
946:
947: -- bug 11691789 : skkoppul added
948: UPDATE PA_BUDGET_VERSIONS
949: SET ACTUAL_AMTS_THRU_PERIOD = l_act_thru_period
950: WHERE BUDGET_VERSION_ID = lx_budget_version_id;
951:
952: --hr_utility.trace('l_etc_fp_type_id : '||l_etc_fp_type_id);