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 1415: (p_project_id IN pa_projects_all.project_id%TYPE ,

1411: --p_budget_version_id is mandatory whenever p_context is PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET.
1412: --When PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_WORKPLAN, data for the version will be deleted when p_budget_version_id
1413: --is passed. Otherwise when p_project_id is passed data for the entire project will be deleted.
1414: procedure Delete_Version_Helper
1415: (p_project_id IN pa_projects_all.project_id%TYPE ,
1416: p_context IN VARCHAR2 ,
1417: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
1418: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1419: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 1830: p_source_project_id IN pa_projects_all.project_id%TYPE,

1826: --All the Input parameters are mandator. No validations are done since this is a private and only called by copy
1827: --version
1828: PROCEDURE get_copy_paramters
1829: (
1830: p_source_project_id IN pa_projects_all.project_id%TYPE,
1831: p_target_project_id IN pa_projects_all.project_id%TYPE,
1832: p_source_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
1833: p_target_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
1834: p_source_version_type IN pa_budget_versions.version_type%TYPE,

Line 1831: p_target_project_id IN pa_projects_all.project_id%TYPE,

1827: --version
1828: PROCEDURE get_copy_paramters
1829: (
1830: p_source_project_id IN pa_projects_all.project_id%TYPE,
1831: p_target_project_id IN pa_projects_all.project_id%TYPE,
1832: p_source_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
1833: p_target_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
1834: p_source_version_type IN pa_budget_versions.version_type%TYPE,
1835: p_target_version_type IN pa_budget_versions.version_type%TYPE,

Line 1989: l_project_id pa_projects_all.project_id%TYPE;

1985: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
1986: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
1987: l_target_profile_id pa_budget_versions.period_profile_id%TYPE;
1988:
1989: l_project_id pa_projects_all.project_id%TYPE;
1990:
1991: -- Bug 3362316, 08-JAN-2003: Local Vars for Populating Reporting Lines --------------------------
1992:
1993:

Line 4172: FROM pa_projects_all pp

4168: SELECT pp.org_id
4169: ,bv.budget_status_code
4170: INTO l_org_id
4171: ,l_budget_status_code
4172: FROM pa_projects_all pp
4173: ,pa_budget_versions bv
4174: WHERE pp.project_id = bv.project_id
4175: AND bv.budget_version_id = p_budget_version_id;
4176: /* End of bug fix:4510784 */

Line 4448: p_project_id IN pa_projects_all.project_id%TYPE,

4444: This api is called from Copy_version and called only in the case of '
4445: ORG_FORECAST'
4446: =========================================================================*/
4447: procedure Create_Org_Fcst_Elements (
4448: p_project_id IN pa_projects_all.project_id%TYPE,
4449: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
4450: p_target_version_id IN pa_budget_versions.budget_version_id%TYPE,
4451: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4452: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 5240: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

5236: l_new_budget_version_id pa_budget_versions.budget_version_id%TYPE;
5237: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
5238: l_dummy_version_id pa_budget_versions.budget_version_id%TYPE;
5239: l_new_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
5240: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
5241: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
5242: l_dummy_currency_code pa_projects_all.projfunc_currency_code%TYPE;
5243: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
5244: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;

Line 5241: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

5237: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
5238: l_dummy_version_id pa_budget_versions.budget_version_id%TYPE;
5239: l_new_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
5240: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
5241: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
5242: l_dummy_currency_code pa_projects_all.projfunc_currency_code%TYPE;
5243: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
5244: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
5245: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;

Line 5242: l_dummy_currency_code pa_projects_all.projfunc_currency_code%TYPE;

5238: l_dummy_version_id pa_budget_versions.budget_version_id%TYPE;
5239: l_new_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
5240: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
5241: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
5242: l_dummy_currency_code pa_projects_all.projfunc_currency_code%TYPE;
5243: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
5244: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
5245: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
5246: l_est_project_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;

Line 5259: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;

5255: l_plan_type_mc_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE; --Bug 2661237
5256:
5257: /* Project level conversion attributes var for bug 2661237 */
5258:
5259: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
5260: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
5261: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5262: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
5263: l_invproc_currency_code pa_projects_all.revproc_currency_code%TYPE;

Line 5260: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;

5256:
5257: /* Project level conversion attributes var for bug 2661237 */
5258:
5259: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
5260: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
5261: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5262: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
5263: l_invproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5264: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;

Line 5261: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;

5257: /* Project level conversion attributes var for bug 2661237 */
5258:
5259: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
5260: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
5261: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5262: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
5263: l_invproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5264: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
5265: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

Line 5262: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;

5258:
5259: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
5260: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
5261: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5262: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
5263: l_invproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5264: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
5265: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
5266: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;

Line 5263: l_invproc_currency_code pa_projects_all.revproc_currency_code%TYPE;

5259: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
5260: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
5261: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5262: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
5263: l_invproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5264: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
5265: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
5266: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
5267: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

Line 5264: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;

5260: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
5261: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5262: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
5263: l_invproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5264: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
5265: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
5266: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
5267: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
5268: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;

Line 5265: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

5261: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5262: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
5263: l_invproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5264: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
5265: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
5266: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
5267: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
5268: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
5269: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

Line 5266: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;

5262: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
5263: l_invproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5264: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
5265: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
5266: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
5267: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
5268: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
5269: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
5270: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

Line 5267: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

5263: l_invproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
5264: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
5265: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
5266: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
5267: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
5268: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
5269: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
5270: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
5271: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

Line 5268: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;

5264: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
5265: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
5266: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
5267: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
5268: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
5269: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
5270: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
5271: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
5272: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

Line 5269: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

5265: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
5266: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
5267: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
5268: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
5269: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
5270: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
5271: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
5272: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
5273: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;

Line 5270: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

5266: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
5267: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
5268: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
5269: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
5270: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
5271: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
5272: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
5273: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
5274: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;

Line 5271: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

5267: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
5268: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
5269: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
5270: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
5271: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
5272: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
5273: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
5274: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
5275: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;

Line 5272: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

5268: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
5269: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
5270: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
5271: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
5272: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
5273: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
5274: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
5275: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
5276:

Line 5273: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;

5269: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
5270: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
5271: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
5272: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
5273: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
5274: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
5275: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
5276:
5277: /* End of variable definition for bug 2661237 */

Line 5274: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;

5270: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
5271: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
5272: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
5273: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
5274: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
5275: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
5276:
5277: /* End of variable definition for bug 2661237 */
5278:

Line 5275: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;

5271: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
5272: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
5273: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
5274: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
5275: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
5276:
5277: /* End of variable definition for bug 2661237 */
5278:
5279: l_res_list_uncategorized_flag VARCHAR2(1);

Line 7151: FROM pa_projects_all

7147: SELECT start_date
7148: ,completion_date
7149: INTO l_project_start_date
7150: ,l_project_completion_date
7151: FROM pa_projects_all
7152: WHERE project_id = p_project_id;
7153:
7154: -- IF both start and completion dates are not null choose them as
7155: -- period profiles' start date and end dates

Line 8493: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;

8489: l_def_txn_curr_code pa_budget_lines.txn_currency_code%TYPE;
8490: l_curr_code_temp_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE(); /* 7161809 */
8491:
8492: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;
8493: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;
8494: l_pfunc_curr_code pa_projects_all.projfunc_currency_code%TYPE;
8495:
8496: l_ci_id pa_budget_versions.ci_id%TYPE;
8497: l_agreement_id pa_budget_versions.agreement_id%TYPE;

Line 8494: l_pfunc_curr_code pa_projects_all.projfunc_currency_code%TYPE;

8490: l_curr_code_temp_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE(); /* 7161809 */
8491:
8492: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;
8493: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;
8494: l_pfunc_curr_code pa_projects_all.projfunc_currency_code%TYPE;
8495:
8496: l_ci_id pa_budget_versions.ci_id%TYPE;
8497: l_agreement_id pa_budget_versions.agreement_id%TYPE;
8498: l_app_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

Line 8585: pa_projects_all ppa

8581: l_app_rev_flag,
8582: l_proj_curr_code,
8583: l_pfunc_curr_code
8584: FROM pa_budget_versions pbv,
8585: pa_projects_all ppa
8586: WHERE pbv.budget_version_id = p_budget_version_id
8587: AND ppa.project_id = pbv.project_id;
8588: EXCEPTION
8589: WHEN NO_DATA_FOUND THEN