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_BUDGET_PVT dependencies on PA_BUDGET_LINES

Line 33: pa_budget_lines.TXN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER ;

29: AND lookup_code = c_change_reason_code;
30:
31: --Bug 2871603: Added the following PLSQL table to remove build dependency.
32: TYPE l_txn_currency_code_tbl_typ IS TABLE OF
33: pa_budget_lines.TXN_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER ;
34:
35: --This record type will contain key and a value. A pl/sql tbl of this record type can be declared and it can be
36: --used for different purposes. One such case is : if its required to get the wbs level for a task id at many
37: --places in the code then instead of firing a select each time we can fetch it and store in this record. The key

Line 348: ,pa_budget_lines bl

344: IS
345: SELECT 'x'
346: FROM pa_budget_versions bv
347: ,pa_resource_assignments ra
348: ,pa_budget_lines bl
349: WHERE bv.budget_version_id = c_budget_version_id
350: AND bv.budget_version_id = ra.budget_version_id (+)
351: AND ra.resource_assignment_id = bl.resource_assignment_id (+)
352: AND bv.ci_id IS NULL -- Bug # 3507156 --Added an extra clause ci_id IS NULL

Line 432: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE;

428: l_is_rate_type_valid BOOLEAN;
429: l_planning_level_lookup CONSTANT VARCHAR2(30) := 'BUDGET ENTRY LEVEL';
430: l_time_phasing_lookup CONSTANT VARCHAR2(30) := 'BUDGET TIME PHASED TYPE';
431: l_validate_mc_attributes VARCHAR2(1);
432: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
433: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
434: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
435: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;
436: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;

Line 433: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;

429: l_planning_level_lookup CONSTANT VARCHAR2(30) := 'BUDGET ENTRY LEVEL';
430: l_time_phasing_lookup CONSTANT VARCHAR2(30) := 'BUDGET TIME PHASED TYPE';
431: l_validate_mc_attributes VARCHAR2(1);
432: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
433: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
434: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
435: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;
436: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
437: l_context_info pa_fin_plan_types_tl.name%TYPE;

Line 434: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE;

430: l_time_phasing_lookup CONSTANT VARCHAR2(30) := 'BUDGET TIME PHASED TYPE';
431: l_validate_mc_attributes VARCHAR2(1);
432: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
433: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
434: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
435: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;
436: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
437: l_context_info pa_fin_plan_types_tl.name%TYPE;
438:

Line 435: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;

431: l_validate_mc_attributes VARCHAR2(1);
432: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
433: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
434: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
435: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;
436: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
437: l_context_info pa_fin_plan_types_tl.name%TYPE;
438:
439: l_called_from_agr_pub VARCHAR2(1) := NULL; -- Bug 3099706

Line 4084: l_budget_start_date pa_budget_lines.start_date%TYPE;

4080: l_pm_task_ref pa_tasks.pm_task_reference%TYPE;
4081: l_resource_alias pa_resource_list_members.alias%TYPE; -- bug 3711693
4082: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
4083: l_cbs_element_id pa_resource_assignments.cbs_element_id%TYPE;--Bug 16604257 : CBS RBS Phase 2 API changes
4084: l_budget_start_date pa_budget_lines.start_date%TYPE;
4085: l_budget_end_date pa_budget_lines.start_date%TYPE;
4086: l_period_name pa_budget_lines.period_name%TYPE;
4087: l_description pa_budget_lines.description%TYPE;
4088: l_pm_budget_line_reference pa_budget_lines.pm_budget_line_reference%TYPE;

Line 4085: l_budget_end_date pa_budget_lines.start_date%TYPE;

4081: l_resource_alias pa_resource_list_members.alias%TYPE; -- bug 3711693
4082: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
4083: l_cbs_element_id pa_resource_assignments.cbs_element_id%TYPE;--Bug 16604257 : CBS RBS Phase 2 API changes
4084: l_budget_start_date pa_budget_lines.start_date%TYPE;
4085: l_budget_end_date pa_budget_lines.start_date%TYPE;
4086: l_period_name pa_budget_lines.period_name%TYPE;
4087: l_description pa_budget_lines.description%TYPE;
4088: l_pm_budget_line_reference pa_budget_lines.pm_budget_line_reference%TYPE;
4089: l_change_reason_code pa_budget_lines.change_reason_code%TYPE;

Line 4086: l_period_name pa_budget_lines.period_name%TYPE;

4082: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
4083: l_cbs_element_id pa_resource_assignments.cbs_element_id%TYPE;--Bug 16604257 : CBS RBS Phase 2 API changes
4084: l_budget_start_date pa_budget_lines.start_date%TYPE;
4085: l_budget_end_date pa_budget_lines.start_date%TYPE;
4086: l_period_name pa_budget_lines.period_name%TYPE;
4087: l_description pa_budget_lines.description%TYPE;
4088: l_pm_budget_line_reference pa_budget_lines.pm_budget_line_reference%TYPE;
4089: l_change_reason_code pa_budget_lines.change_reason_code%TYPE;
4090:

Line 4087: l_description pa_budget_lines.description%TYPE;

4083: l_cbs_element_id pa_resource_assignments.cbs_element_id%TYPE;--Bug 16604257 : CBS RBS Phase 2 API changes
4084: l_budget_start_date pa_budget_lines.start_date%TYPE;
4085: l_budget_end_date pa_budget_lines.start_date%TYPE;
4086: l_period_name pa_budget_lines.period_name%TYPE;
4087: l_description pa_budget_lines.description%TYPE;
4088: l_pm_budget_line_reference pa_budget_lines.pm_budget_line_reference%TYPE;
4089: l_change_reason_code pa_budget_lines.change_reason_code%TYPE;
4090:
4091: l_budget_lines_in_tbl PA_BUDGET_PUB.G_BUDGET_LINES_IN_TBL%TYPE; /* bug 2998221 */

Line 4088: l_pm_budget_line_reference pa_budget_lines.pm_budget_line_reference%TYPE;

4084: l_budget_start_date pa_budget_lines.start_date%TYPE;
4085: l_budget_end_date pa_budget_lines.start_date%TYPE;
4086: l_period_name pa_budget_lines.period_name%TYPE;
4087: l_description pa_budget_lines.description%TYPE;
4088: l_pm_budget_line_reference pa_budget_lines.pm_budget_line_reference%TYPE;
4089: l_change_reason_code pa_budget_lines.change_reason_code%TYPE;
4090:
4091: l_budget_lines_in_tbl PA_BUDGET_PUB.G_BUDGET_LINES_IN_TBL%TYPE; /* bug 2998221 */
4092: l_budget_lines_out_tbl PA_BUDGET_PUB.G_BUDGET_LINES_OUT_TBL%TYPE;

Line 4089: l_change_reason_code pa_budget_lines.change_reason_code%TYPE;

4085: l_budget_end_date pa_budget_lines.start_date%TYPE;
4086: l_period_name pa_budget_lines.period_name%TYPE;
4087: l_description pa_budget_lines.description%TYPE;
4088: l_pm_budget_line_reference pa_budget_lines.pm_budget_line_reference%TYPE;
4089: l_change_reason_code pa_budget_lines.change_reason_code%TYPE;
4090:
4091: l_budget_lines_in_tbl PA_BUDGET_PUB.G_BUDGET_LINES_IN_TBL%TYPE; /* bug 2998221 */
4092: l_budget_lines_out_tbl PA_BUDGET_PUB.G_BUDGET_LINES_OUT_TBL%TYPE;
4093: i NUMBER;

Line 4817: SELECT pa_budget_lines.*, rowid

4813: CURSOR l_budget_line_csr
4814: (p_resource_assigment_id NUMBER
4815: ,p_budget_start_date DATE )
4816: IS
4817: SELECT pa_budget_lines.*, rowid
4818: FROM pa_budget_lines
4819: WHERE resource_assignment_id = p_resource_assigment_id
4820: AND start_date = p_budget_start_date;
4821:

Line 4818: FROM pa_budget_lines

4814: (p_resource_assigment_id NUMBER
4815: ,p_budget_start_date DATE )
4816: IS
4817: SELECT pa_budget_lines.*, rowid
4818: FROM pa_budget_lines
4819: WHERE resource_assignment_id = p_resource_assigment_id
4820: AND start_date = p_budget_start_date;
4821:
4822: --cursor added as part of fix for Bug#1406799 to check the burdened_cost_flag

Line 4847: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%type;

4843: -- added as part of fix for Bug#1406799 to check for burdened_cost_flag
4844: l_burdened_cost_flag VARCHAR2(1) := 'Y';
4845:
4846: /* FPB2: MRC */
4847: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%type;
4848: l_budget_version_id PA_BUDGET_LINES.BUDGET_VERSION_ID%type;
4849: l_txn_currency_code PA_BUDGET_LINES.TXN_CURRENCY_CODE%type;
4850: l_msg_count NUMBER := 0;
4851: l_msg_data VARCHAR2(2000);

Line 4848: l_budget_version_id PA_BUDGET_LINES.BUDGET_VERSION_ID%type;

4844: l_burdened_cost_flag VARCHAR2(1) := 'Y';
4845:
4846: /* FPB2: MRC */
4847: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%type;
4848: l_budget_version_id PA_BUDGET_LINES.BUDGET_VERSION_ID%type;
4849: l_txn_currency_code PA_BUDGET_LINES.TXN_CURRENCY_CODE%type;
4850: l_msg_count NUMBER := 0;
4851: l_msg_data VARCHAR2(2000);
4852:

Line 4849: l_txn_currency_code PA_BUDGET_LINES.TXN_CURRENCY_CODE%type;

4845:
4846: /* FPB2: MRC */
4847: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%type;
4848: l_budget_version_id PA_BUDGET_LINES.BUDGET_VERSION_ID%type;
4849: l_txn_currency_code PA_BUDGET_LINES.TXN_CURRENCY_CODE%type;
4850: l_msg_count NUMBER := 0;
4851: l_msg_data VARCHAR2(2000);
4852:
4853:

Line 4875: l_statement := ' UPDATE PA_BUDGET_LINES SET ';

4871:
4872: --building the dynamic SQL statement
4873: -- Changes made by Xin Liu for using of SQL BIND VARIABLE 12-MAY-2003
4874:
4875: l_statement := ' UPDATE PA_BUDGET_LINES SET ';
4876:
4877: --dbms_output.put_line('p_description : '||p_description);
4878: --dbms_output.put_line('l_budget_line_rec.description: '||l_budget_line_rec.description);
4879:

Line 5389: FROM pa_budget_lines

5385: /* FPB2: MRC */
5386: BEGIN
5387: SELECT budget_line_id, budget_version_id --Bug 4224464
5388: INTO l_budget_line_id, l_budget_version_id
5389: FROM pa_budget_lines
5390: WHERE resource_assignment_id = p_resource_assignment_id
5391: AND start_date = p_start_date
5392: AND txn_currency_code = l_txn_currency_code;
5393: EXCEPTION

Line 5458: PA_BUDGET_LINES_V_PKG.delete_row

5454: THEN
5455:
5456: BEGIN
5457: --dbms_output.put_line('About to delete the budget line because of zero values');
5458: PA_BUDGET_LINES_V_PKG.delete_row
5459: ( x_rowid => l_budget_line_rec.rowid );
5460: -- Bug Fix: 4569365. Removed MRC code.
5461: -- ,x_mrc_flag => 'Y'); /* FPB2: MRC */
5462:

Line 5499: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'

5495:
5496: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5497: THEN
5498: FND_MSG_PUB.add_exc_msg
5499: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'
5500: , p_procedure_name => 'DELETE_ROW'
5501: , p_error_text => SQLCODE );
5502: END IF;
5503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5710: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE

5706: ,p_multi_currency_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
5707: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
5708: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
5709: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
5710: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE
5711: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
5712: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
5713: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
5714: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE

Line 5714: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE

5710: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE
5711: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
5712: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
5713: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
5714: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
5715: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
5716: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
5717: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
5718: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE

Line 5718: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE

5714: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
5715: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
5716: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
5717: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
5718: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
5719: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
5720: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
5721: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
5722: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE

Line 5722: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE

5718: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
5719: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
5720: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
5721: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
5722: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
5723:
5724: /* Bug 3986129: FP.M Web ADI Dev changes: New parameters added */
5725: ,p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols
5726: ,p_allow_raw_cost_rate_flag IN VARCHAR2

Line 5921: l_pm_product_code pa_budget_lines.pm_product_code%TYPE;

5917: l_valid_rlmid VARCHAR2(1);
5918: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
5919: l_resource_type_code pa_resource_list_members.resource_type_code%TYPE;
5920: l_context_info pa_fin_plan_types_tl.name%TYPE;
5921: l_pm_product_code pa_budget_lines.pm_product_code%TYPE;
5922:
5923: -- Cursor used in validating the product code
5924: Cursor p_product_code_csr (c_pm_product_code IN VARCHAR2)
5925: Is

Line 5958: l_wa_project_cost_exc_rate pa_budget_lines.project_cost_exchange_rate%TYPE;

5954:
5955: l_wa_project_cost_rate_typ pa_proj_fp_options.project_cost_rate_type%TYPE;
5956: l_wa_project_cost_rate_dt_typ pa_proj_fp_options.project_cost_rate_date_type%TYPE;
5957: l_wa_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE;
5958: l_wa_project_cost_exc_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
5959: l_wa_projfunc_cost_rate_typ pa_proj_fp_options.projfunc_cost_rate_type%TYPE;
5960: l_wa_projfunc_cost_rate_dt_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;
5961: l_wa_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE;
5962: l_wa_projfunc_cost_exc_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;

Line 5962: l_wa_projfunc_cost_exc_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;

5958: l_wa_project_cost_exc_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
5959: l_wa_projfunc_cost_rate_typ pa_proj_fp_options.projfunc_cost_rate_type%TYPE;
5960: l_wa_projfunc_cost_rate_dt_typ pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;
5961: l_wa_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE;
5962: l_wa_projfunc_cost_exc_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
5963: l_wa_project_rev_rate_typ pa_proj_fp_options.project_rev_rate_type%TYPE;
5964: l_wa_project_rev_rate_dt_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE;
5965: l_wa_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE;
5966: l_wa_project_rev_exc_rate pa_budget_lines.project_rev_exchange_rate%TYPE;

Line 5966: l_wa_project_rev_exc_rate pa_budget_lines.project_rev_exchange_rate%TYPE;

5962: l_wa_projfunc_cost_exc_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
5963: l_wa_project_rev_rate_typ pa_proj_fp_options.project_rev_rate_type%TYPE;
5964: l_wa_project_rev_rate_dt_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE;
5965: l_wa_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE;
5966: l_wa_project_rev_exc_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
5967: l_wa_projfunc_rev_rate_typ pa_proj_fp_options.projfunc_rev_rate_type%TYPE;
5968: l_wa_projfunc_rev_rate_dt_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
5969: l_wa_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE;
5970: l_wa_projfunc_rev_exc_rate pa_budget_lines.project_rev_exchange_rate%TYPE;

Line 5970: l_wa_projfunc_rev_exc_rate pa_budget_lines.project_rev_exchange_rate%TYPE;

5966: l_wa_project_rev_exc_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
5967: l_wa_projfunc_rev_rate_typ pa_proj_fp_options.projfunc_rev_rate_type%TYPE;
5968: l_wa_projfunc_rev_rate_dt_typ pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE;
5969: l_wa_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE;
5970: l_wa_projfunc_rev_exc_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
5971: l_wa_val_conv_attr_flag VARCHAR2(1);
5972: l_calling_model_context VARCHAR(30);
5973:
5974:

Line 8683: FROM pa_resource_assignments ra , pa_budget_lines bl

8679: DECODE(bl.other_rejection_code,NULL,
8680: DECODE(bl.pfc_cur_conv_rejection_code,NULL,
8681: DECODE(bl.pc_cur_conv_rejection_code,NULL,NULL,'E')
8682: ,'E'),'E'),'E'),'E'),'E') return_status
8683: FROM pa_resource_assignments ra , pa_budget_lines bl
8684: where ra.budget_version_id = p_fin_plan_version_id
8685: and ra.resource_assignment_id = bl.resource_assignment_id;
8686:
8687: BEGIN