eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FIN_PLAN_PUB dependencies on PA_PROJECTS_ALL

Line 938: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;

934: l_wp_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
935: l_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
936:
937: /* Bug 2688610 - Add the following two locals*/
938: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
939: l_approved_rev_plan_type_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
940:
941: -- Bug 3354518 FP M Doosan Phase 1 changes
942: l_current_original_flag pa_budget_versions.current_original_flag%TYPE;

Line 1075: from pa_projects_all p, pa_budget_versions v

1071: */
1072: BEGIN
1073: select p.baseline_funding_flag, v.approved_rev_plan_type_flag
1074: into l_baseline_funding_flag, l_approved_rev_plan_type_flag
1075: from pa_projects_all p, pa_budget_versions v
1076: where p.project_id = v.project_id
1077: and v.budget_version_id = p_budget_version_id;
1078: EXCEPTION
1079: WHEN NO_DATA_FOUND THEN

Line 1431: (p_project_id IN pa_projects_all.project_id%TYPE ,

1427: --p_budget_version_id is mandatory whenever p_context is PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET.
1428: --When PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_WORKPLAN, data for the version will be deleted when p_budget_version_id
1429: --is passed. Otherwise when p_project_id is passed data for the entire project will be deleted.
1430: procedure Delete_Version_Helper
1431: (p_project_id IN pa_projects_all.project_id%TYPE ,
1432: p_context IN VARCHAR2 ,
1433: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
1434: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1435: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 1846: p_source_project_id IN pa_projects_all.project_id%TYPE,

1842: --All the Input parameters are mandator. No validations are done since this is a private and only called by copy
1843: --version
1844: PROCEDURE get_copy_paramters
1845: (
1846: p_source_project_id IN pa_projects_all.project_id%TYPE,
1847: p_target_project_id IN pa_projects_all.project_id%TYPE,
1848: p_source_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
1849: p_target_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
1850: p_source_version_type IN pa_budget_versions.version_type%TYPE,

Line 1847: p_target_project_id IN pa_projects_all.project_id%TYPE,

1843: --version
1844: PROCEDURE get_copy_paramters
1845: (
1846: p_source_project_id IN pa_projects_all.project_id%TYPE,
1847: p_target_project_id IN pa_projects_all.project_id%TYPE,
1848: p_source_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
1849: p_target_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
1850: p_source_version_type IN pa_budget_versions.version_type%TYPE,
1851: p_target_version_type IN pa_budget_versions.version_type%TYPE,

Line 2005: l_project_id pa_projects_all.project_id%TYPE;

2001: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
2002: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
2003: l_target_profile_id pa_budget_versions.period_profile_id%TYPE;
2004:
2005: l_project_id pa_projects_all.project_id%TYPE;
2006:
2007: -- Bug 3362316, 08-JAN-2003: Local Vars for Populating Reporting Lines --------------------------
2008:
2009:

Line 4188: FROM pa_projects_all pp

4184: SELECT pp.org_id
4185: ,bv.budget_status_code
4186: INTO l_org_id
4187: ,l_budget_status_code
4188: FROM pa_projects_all pp
4189: ,pa_budget_versions bv
4190: WHERE pp.project_id = bv.project_id
4191: AND bv.budget_version_id = p_budget_version_id;
4192: /* End of bug fix:4510784 */

Line 4464: p_project_id IN pa_projects_all.project_id%TYPE,

4460: This api is called from Copy_version and called only in the case of '
4461: ORG_FORECAST'
4462: =========================================================================*/
4463: procedure Create_Org_Fcst_Elements (
4464: p_project_id IN pa_projects_all.project_id%TYPE,
4465: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
4466: p_target_version_id IN pa_budget_versions.budget_version_id%TYPE,
4467: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4468: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 5256: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

5252: l_new_budget_version_id pa_budget_versions.budget_version_id%TYPE;
5253: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
5254: l_dummy_version_id pa_budget_versions.budget_version_id%TYPE;
5255: l_new_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
5256: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
5257: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
5258: l_dummy_currency_code pa_projects_all.projfunc_currency_code%TYPE;
5259: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
5260: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;

Line 5257: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

5253: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
5254: l_dummy_version_id pa_budget_versions.budget_version_id%TYPE;
5255: l_new_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
5256: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
5257: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
5258: l_dummy_currency_code pa_projects_all.projfunc_currency_code%TYPE;
5259: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
5260: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
5261: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;

Line 5258: l_dummy_currency_code pa_projects_all.projfunc_currency_code%TYPE;

5254: l_dummy_version_id pa_budget_versions.budget_version_id%TYPE;
5255: l_new_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
5256: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
5257: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
5258: l_dummy_currency_code pa_projects_all.projfunc_currency_code%TYPE;
5259: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
5260: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
5261: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
5262: l_est_project_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;

Line 5275: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;

5271: l_plan_type_mc_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE; --Bug 2661237
5272:
5273: /* Project level conversion attributes var for bug 2661237 */
5274:
5275: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
5276: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
5277: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5278: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
5279: l_invproc_currency_code pa_projects_all.revproc_currency_code%TYPE;

Line 5276: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;

5272:
5273: /* Project level conversion attributes var for bug 2661237 */
5274:
5275: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
5276: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
5277: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5278: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
5279: l_invproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5280: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;

Line 5277: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;

5273: /* Project level conversion attributes var for bug 2661237 */
5274:
5275: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
5276: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
5277: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5278: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
5279: l_invproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5280: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
5281: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

Line 5278: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;

5274:
5275: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
5276: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
5277: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5278: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
5279: l_invproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5280: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
5281: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
5282: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;

Line 5279: l_invproc_currency_code pa_projects_all.revproc_currency_code%TYPE;

5275: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
5276: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
5277: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5278: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
5279: l_invproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5280: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
5281: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
5282: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
5283: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

Line 5280: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;

5276: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
5277: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5278: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
5279: l_invproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5280: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
5281: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
5282: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
5283: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
5284: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;

Line 5281: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

5277: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5278: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
5279: l_invproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5280: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
5281: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
5282: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
5283: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
5284: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
5285: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

Line 5282: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;

5278: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
5279: l_invproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5280: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
5281: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
5282: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
5283: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
5284: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
5285: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
5286: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

Line 5283: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

5279: l_invproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5280: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
5281: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
5282: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
5283: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
5284: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
5285: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
5286: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
5287: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

Line 5284: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;

5280: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
5281: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
5282: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
5283: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
5284: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
5285: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
5286: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
5287: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
5288: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

Line 5285: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

5281: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
5282: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
5283: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
5284: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
5285: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
5286: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
5287: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
5288: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
5289: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;

Line 5286: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

5282: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
5283: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
5284: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
5285: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
5286: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
5287: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
5288: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
5289: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
5290: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;

Line 5287: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

5283: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
5284: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
5285: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
5286: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
5287: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
5288: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
5289: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
5290: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
5291: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;

Line 5288: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

5284: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
5285: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
5286: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
5287: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
5288: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
5289: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
5290: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
5291: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
5292:

Line 5289: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;

5285: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
5286: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
5287: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
5288: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
5289: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
5290: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
5291: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
5292:
5293: /* End of variable definition for bug 2661237 */

Line 5290: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;

5286: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
5287: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
5288: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
5289: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
5290: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
5291: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
5292:
5293: /* End of variable definition for bug 2661237 */
5294:

Line 5291: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;

5287: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
5288: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
5289: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
5290: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
5291: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
5292:
5293: /* End of variable definition for bug 2661237 */
5294:
5295: l_res_list_uncategorized_flag VARCHAR2(1);

Line 7171: FROM pa_projects_all

7167: SELECT start_date
7168: ,completion_date
7169: INTO l_project_start_date
7170: ,l_project_completion_date
7171: FROM pa_projects_all
7172: WHERE project_id = p_project_id;
7173:
7174: -- IF both start and completion dates are not null choose them as
7175: -- period profiles' start date and end dates

Line 8526: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;

8522: l_def_txn_curr_code pa_budget_lines.txn_currency_code%TYPE;
8523: l_curr_code_temp_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE(); /* 7161809 */
8524: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(); /* EnC */
8525: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;
8526: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;
8527: l_pfunc_curr_code pa_projects_all.projfunc_currency_code%TYPE;
8528:
8529: l_ci_id pa_budget_versions.ci_id%TYPE;
8530: l_agreement_id pa_budget_versions.agreement_id%TYPE;

Line 8527: l_pfunc_curr_code pa_projects_all.projfunc_currency_code%TYPE;

8523: l_curr_code_temp_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE(); /* 7161809 */
8524: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(); /* EnC */
8525: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;
8526: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;
8527: l_pfunc_curr_code pa_projects_all.projfunc_currency_code%TYPE;
8528:
8529: l_ci_id pa_budget_versions.ci_id%TYPE;
8530: l_agreement_id pa_budget_versions.agreement_id%TYPE;
8531: l_app_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

Line 8626: pa_projects_all ppa

8622: l_app_rev_flag,
8623: l_proj_curr_code,
8624: l_pfunc_curr_code
8625: FROM pa_budget_versions pbv,
8626: pa_projects_all ppa
8627: WHERE pbv.budget_version_id = p_budget_version_id
8628: AND ppa.project_id = pbv.project_id;
8629: EXCEPTION
8630: WHEN NO_DATA_FOUND THEN