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_FP_WEBADI_UTILS dependencies on PA_PROJ_FP_OPTIONS

Line 31: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

27: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
28: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
29: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
30: IS
31: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
32: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
33: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
34: l_uncategorized_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;
35: l_group_resource_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;

Line 32: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

28: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
29: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
30: IS
31: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
32: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
33: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
34: l_uncategorized_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;
35: l_group_resource_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
36: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

Line 33: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;

29: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
30: IS
31: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
32: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
33: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
34: l_uncategorized_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;
35: l_group_resource_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
36: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
37: l_project_id pa_proj_fp_options.project_id%TYPE;

Line 36: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

32: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
33: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
34: l_uncategorized_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;
35: l_group_resource_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
36: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
37: l_project_id pa_proj_fp_options.project_id%TYPE;
38: l_cost_layout_code pa_proj_fp_options.cost_layout_code%TYPE;
39: l_revenue_layout_code pa_proj_fp_options.revenue_layout_code%TYPE;
40: l_all_layout_code pa_proj_fp_options.all_layout_code%TYPE;

Line 37: l_project_id pa_proj_fp_options.project_id%TYPE;

33: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
34: l_uncategorized_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;
35: l_group_resource_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
36: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
37: l_project_id pa_proj_fp_options.project_id%TYPE;
38: l_cost_layout_code pa_proj_fp_options.cost_layout_code%TYPE;
39: l_revenue_layout_code pa_proj_fp_options.revenue_layout_code%TYPE;
40: l_all_layout_code pa_proj_fp_options.all_layout_code%TYPE;
41: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

Line 38: l_cost_layout_code pa_proj_fp_options.cost_layout_code%TYPE;

34: l_uncategorized_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;
35: l_group_resource_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
36: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
37: l_project_id pa_proj_fp_options.project_id%TYPE;
38: l_cost_layout_code pa_proj_fp_options.cost_layout_code%TYPE;
39: l_revenue_layout_code pa_proj_fp_options.revenue_layout_code%TYPE;
40: l_all_layout_code pa_proj_fp_options.all_layout_code%TYPE;
41: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
42: l_cost_time_phased_code pa_proj_fp_options.cost_time_phased_Code%TYPE;

Line 39: l_revenue_layout_code pa_proj_fp_options.revenue_layout_code%TYPE;

35: l_group_resource_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
36: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
37: l_project_id pa_proj_fp_options.project_id%TYPE;
38: l_cost_layout_code pa_proj_fp_options.cost_layout_code%TYPE;
39: l_revenue_layout_code pa_proj_fp_options.revenue_layout_code%TYPE;
40: l_all_layout_code pa_proj_fp_options.all_layout_code%TYPE;
41: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
42: l_cost_time_phased_code pa_proj_fp_options.cost_time_phased_Code%TYPE;
43: l_revenue_time_phased_Code pa_proj_fp_options.revenue_time_phased_Code%TYPE;

Line 40: l_all_layout_code pa_proj_fp_options.all_layout_code%TYPE;

36: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
37: l_project_id pa_proj_fp_options.project_id%TYPE;
38: l_cost_layout_code pa_proj_fp_options.cost_layout_code%TYPE;
39: l_revenue_layout_code pa_proj_fp_options.revenue_layout_code%TYPE;
40: l_all_layout_code pa_proj_fp_options.all_layout_code%TYPE;
41: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
42: l_cost_time_phased_code pa_proj_fp_options.cost_time_phased_Code%TYPE;
43: l_revenue_time_phased_Code pa_proj_fp_options.revenue_time_phased_Code%TYPE;
44: l_all_time_phased_Code pa_proj_fp_options.all_time_phased_Code%TYPE;

Line 42: l_cost_time_phased_code pa_proj_fp_options.cost_time_phased_Code%TYPE;

38: l_cost_layout_code pa_proj_fp_options.cost_layout_code%TYPE;
39: l_revenue_layout_code pa_proj_fp_options.revenue_layout_code%TYPE;
40: l_all_layout_code pa_proj_fp_options.all_layout_code%TYPE;
41: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
42: l_cost_time_phased_code pa_proj_fp_options.cost_time_phased_Code%TYPE;
43: l_revenue_time_phased_Code pa_proj_fp_options.revenue_time_phased_Code%TYPE;
44: l_all_time_phased_Code pa_proj_fp_options.all_time_phased_Code%TYPE;
45: l_integrator_code bne_layouts_b.integrator_code%TYPE;
46: l_cost_period_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE;

Line 43: l_revenue_time_phased_Code pa_proj_fp_options.revenue_time_phased_Code%TYPE;

39: l_revenue_layout_code pa_proj_fp_options.revenue_layout_code%TYPE;
40: l_all_layout_code pa_proj_fp_options.all_layout_code%TYPE;
41: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
42: l_cost_time_phased_code pa_proj_fp_options.cost_time_phased_Code%TYPE;
43: l_revenue_time_phased_Code pa_proj_fp_options.revenue_time_phased_Code%TYPE;
44: l_all_time_phased_Code pa_proj_fp_options.all_time_phased_Code%TYPE;
45: l_integrator_code bne_layouts_b.integrator_code%TYPE;
46: l_cost_period_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE;
47: l_revenue_period_mask_id pa_proj_fp_options.rev_period_mask_id%TYPE;

Line 44: l_all_time_phased_Code pa_proj_fp_options.all_time_phased_Code%TYPE;

40: l_all_layout_code pa_proj_fp_options.all_layout_code%TYPE;
41: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
42: l_cost_time_phased_code pa_proj_fp_options.cost_time_phased_Code%TYPE;
43: l_revenue_time_phased_Code pa_proj_fp_options.revenue_time_phased_Code%TYPE;
44: l_all_time_phased_Code pa_proj_fp_options.all_time_phased_Code%TYPE;
45: l_integrator_code bne_layouts_b.integrator_code%TYPE;
46: l_cost_period_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE;
47: l_revenue_period_mask_id pa_proj_fp_options.rev_period_mask_id%TYPE;
48: l_all_period_mask_id pa_proj_fp_options.all_period_mask_id%TYPE;

Line 46: l_cost_period_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE;

42: l_cost_time_phased_code pa_proj_fp_options.cost_time_phased_Code%TYPE;
43: l_revenue_time_phased_Code pa_proj_fp_options.revenue_time_phased_Code%TYPE;
44: l_all_time_phased_Code pa_proj_fp_options.all_time_phased_Code%TYPE;
45: l_integrator_code bne_layouts_b.integrator_code%TYPE;
46: l_cost_period_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE;
47: l_revenue_period_mask_id pa_proj_fp_options.rev_period_mask_id%TYPE;
48: l_all_period_mask_id pa_proj_fp_options.all_period_mask_id%TYPE;
49: l_no_of_periods NUMBER;
50: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;

Line 47: l_revenue_period_mask_id pa_proj_fp_options.rev_period_mask_id%TYPE;

43: l_revenue_time_phased_Code pa_proj_fp_options.revenue_time_phased_Code%TYPE;
44: l_all_time_phased_Code pa_proj_fp_options.all_time_phased_Code%TYPE;
45: l_integrator_code bne_layouts_b.integrator_code%TYPE;
46: l_cost_period_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE;
47: l_revenue_period_mask_id pa_proj_fp_options.rev_period_mask_id%TYPE;
48: l_all_period_mask_id pa_proj_fp_options.all_period_mask_id%TYPE;
49: l_no_of_periods NUMBER;
50: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
51: l_layout_meaning bne_layouts_vl.user_name%TYPE;

Line 48: l_all_period_mask_id pa_proj_fp_options.all_period_mask_id%TYPE;

44: l_all_time_phased_Code pa_proj_fp_options.all_time_phased_Code%TYPE;
45: l_integrator_code bne_layouts_b.integrator_code%TYPE;
46: l_cost_period_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE;
47: l_revenue_period_mask_id pa_proj_fp_options.rev_period_mask_id%TYPE;
48: l_all_period_mask_id pa_proj_fp_options.all_period_mask_id%TYPE;
49: l_no_of_periods NUMBER;
50: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
51: l_layout_meaning bne_layouts_vl.user_name%TYPE;
52: l_plan_class_name pa_lookups.meaning%TYPE;

Line 94: FROM pa_proj_fp_options

90: ,l_all_time_phased_code
91: ,l_cost_period_mask_id
92: ,l_revenue_period_mask_id
93: ,l_all_period_mask_id
94: FROM pa_proj_fp_options
95: WHERE fin_plan_version_id = p_budget_version_id
96: AND FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_VERSION';
97:
98: SELECT pfo.cost_layout_code

Line 106: FROM pa_proj_fp_options pfo

102: INTO l_cost_layout_code
103: ,l_revenue_layout_code
104: ,l_all_layout_code
105: ,l_plan_class_code
106: FROM pa_proj_fp_options pfo
107: ,pa_fin_plan_types_b ptb
108: WHERE pfo.fin_plan_type_id = l_fin_plan_type_id
109: AND pfo.FIN_PLAN_version_id IS NULL
110: AND pfo.fin_plan_type_id = ptb.fin_plan_type_id

Line 387: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

383: l_res_asg_id NUMBER;
384: l_project_id NUMBER;
385: l_task_id NUMBER;
386: l_period_profile_id NUMBER;
387: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
388: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
389: l_project_start_date DATE;
390: l_project_end_date DATE;
391: k NUMBER;

Line 388: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;

384: l_project_id NUMBER;
385: l_task_id NUMBER;
386: l_period_profile_id NUMBER;
387: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
388: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
389: l_project_start_date DATE;
390: l_project_end_date DATE;
391: k NUMBER;
392: m NUMBER;

Line 557: from pa_proj_fp_options fp, pa_budget_versions bv

553: select fp.PLAN_IN_MULTI_CURR_FLAG,
554: fp.proj_fp_options_id
555: into l_multi_curr_flag,
556: l_proj_fp_options_id
557: from pa_proj_fp_options fp, pa_budget_versions bv
558: where bv.budget_version_id = p_budget_version_id
559: and fp.fin_plan_version_id = p_budget_version_id
560: and fp.fin_plan_type_id = bv.fin_plan_type_id
561: and fp.fin_plan_option_level_code = 'PLAN_VERSION'

Line 600: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;

596: l_budget_version_id NUMBER;
597: l_rlm_id_gp NUMBER;
598: l_rlm_id_alias NUMBER;
599: l_project_id NUMBER;
600: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
601: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
602: l_uncategorized_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;
603: l_group_resource_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
604: l_row_id ROWID;

Line 601: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

597: l_rlm_id_gp NUMBER;
598: l_rlm_id_alias NUMBER;
599: l_project_id NUMBER;
600: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
601: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
602: l_uncategorized_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;
603: l_group_resource_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
604: l_row_id ROWID;
605: ll_error_flag VARCHAR2(1);

Line 735: ,p_planning_level IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE

731: END;
732:
733: PROCEDURE GET_RES_ASSIGNMENT_INFO
734: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
735: ,p_planning_level IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
736: ,x_task_number OUT NOCOPY pa_tasks.task_number%TYPE --File.Sql.39 bug 4440895
737: ,x_task_id OUT NOCOPY pa_tasks.task_id%TYPE --File.Sql.39 bug 4440895
738: ,x_resource_alias OUT NOCOPY pa_resource_list_members.alias%TYPE --File.Sql.39 bug 4440895
739: ,x_resource_group_alias OUT NOCOPY pa_resource_list_members.alias%TYPE --File.Sql.39 bug 4440895

Line 1060: ,p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE

1056: */ -- end of bug 5350437
1057:
1058: PROCEDURE VALIDATE_TXN_CURRENCY_CODE
1059: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
1060: ,p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
1061: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
1062: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1063: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1064: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 2278: (p_layout_code IN pa_proj_fp_options.cost_layout_code%TYPE

2274: 06-Apr-2005 prachand Created as a part of WebAdi changes.
2275: Initial Creation
2276: ===================================================================================*/
2277: PROCEDURE get_layout_details
2278: (p_layout_code IN pa_proj_fp_options.cost_layout_code%TYPE
2279: ,p_integrator_code IN bne_integrators_b.integrator_code%TYPE
2280: ,x_layout_name OUT NOCOPY bne_layouts_tl.user_name%TYPE --File.Sql.39 bug 4440895
2281: ,x_layout_type_code OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
2282: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2749: p_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE,

2745: FUNCTION get_current_amount(
2746: p_fin_plan_type_id NUMBER,
2747: p_plan_class_code VARCHAR2,
2748: p_project_id NUMBER,
2749: p_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE,
2750: p_task_id NUMBER,
2751: p_resource_list_member_id NUMBER,
2752: p_uom pa_resource_assignments.unit_of_measure%TYPE,
2753: p_txn_curr_code pa_budget_lines.txn_currency_code%TYPE,

Line 2790: pa_proj_fp_options pfo

2786: begin
2787: select pbv.budget_version_id
2788: into l_curr_bv_id
2789: from pa_budget_versions pbv,
2790: pa_proj_fp_options pfo
2791: where pfo.fin_plan_type_id = p_fin_plan_type_id
2792: and pfo.project_id = p_project_id
2793: and pfo.fin_plan_option_level_code = 'PLAN_VERSION'
2794: and pfo.fin_plan_preference_code = p_fin_plan_preference_code

Line 2807: from pa_proj_fp_options po,

2803: -- looking for APPROVED COST BUDGET plan type
2804: begin
2805: select bv.budget_version_id
2806: into l_curr_bv_id
2807: from pa_proj_fp_options po,
2808: pa_budget_versions bv
2809: where po.project_id = p_project_id and
2810: po.fin_plan_option_level_code = 'PLAN_VERSION' and
2811: bv.approved_cost_plan_type_flag = 'Y' and

Line 2823: from pa_proj_fp_options po,

2819: -- looking for APPROVED REVENUE BUDGET plan type
2820: begin
2821: select bv.budget_version_id
2822: into l_curr_bv_id
2823: from pa_proj_fp_options po,
2824: pa_budget_versions bv
2825: where po.project_id = p_project_id and
2826: po.fin_plan_option_level_code = 'PLAN_VERSION' and
2827: bv.approved_rev_plan_type_flag = 'Y' and

Line 2959: p_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE,

2955: FUNCTION get_original_amount(
2956: p_fin_plan_type_id NUMBER,
2957: p_plan_class_code VARCHAR2,
2958: p_project_id NUMBER,
2959: p_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE,
2960: p_task_id NUMBER,
2961: p_resource_list_member_id NUMBER,
2962: p_uom pa_resource_assignments.unit_of_measure%TYPE,
2963: p_txn_curr_code pa_budget_lines.txn_currency_code%TYPE,

Line 2994: pa_proj_fp_options pfo

2990: begin
2991: select pbv.budget_version_id
2992: into l_orig_bv_id
2993: from pa_budget_versions pbv,
2994: pa_proj_fp_options pfo
2995: where pfo.fin_plan_type_id = p_fin_plan_type_id
2996: and pfo.project_id = p_project_id
2997: and pfo.fin_plan_option_level_code = 'PLAN_VERSION'
2998: and pfo.fin_plan_preference_code = p_fin_plan_preference_code

Line 3011: from pa_proj_fp_options po,

3007: -- looking for APPROVED COST BUDGET plan type
3008: begin
3009: select bv.budget_version_id
3010: into l_orig_bv_id
3011: from pa_proj_fp_options po,
3012: pa_budget_versions bv
3013: where po.project_id = p_project_id and
3014: po.fin_plan_option_level_code = 'PLAN_VERSION' and
3015: bv.approved_cost_plan_type_flag = 'Y' and

Line 3027: from pa_proj_fp_options po,

3023: -- looking for APPROVED REVENUE BUDGET plan type
3024: begin
3025: select bv.budget_version_id
3026: into l_orig_bv_id
3027: from pa_proj_fp_options po,
3028: pa_budget_versions bv
3029: where po.project_id = p_project_id and
3030: po.fin_plan_option_level_code = 'PLAN_VERSION' and
3031: bv.approved_rev_plan_type_flag = 'Y' and

Line 3043: from pa_proj_fp_options po,

3039: -- looking for APPROVED COST AND REVENUE BUDGET plan type
3040: begin
3041: select bv.budget_version_id
3042: into l_orig_bv_id
3043: from pa_proj_fp_options po,
3044: pa_budget_versions bv
3045: where po.project_id = p_project_id and
3046: po.fin_plan_option_level_code = 'PLAN_VERSION' and
3047: bv.approved_cost_plan_type_flag = 'Y' and

Line 3147: p_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE,

3143: FUNCTION get_prior_forecast_amount(
3144: p_fin_plan_type_id NUMBER,
3145: p_plan_class_code VARCHAR2,
3146: p_project_id NUMBER,
3147: p_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE,
3148: p_task_id NUMBER,
3149: p_resource_list_member_id NUMBER,
3150: p_uom pa_resource_assignments.unit_of_measure%TYPE,
3151: p_txn_curr_code pa_budget_lines.txn_currency_code%TYPE,

Line 3185: pa_proj_fp_options pfo

3181: begin
3182: select pbv.budget_version_id
3183: into l_pf_bv_id
3184: from pa_budget_versions pbv,
3185: pa_proj_fp_options pfo
3186: where pfo.fin_plan_type_id = p_fin_plan_type_id
3187: and pfo.project_id = p_project_id
3188: and pfo.fin_plan_option_level_code = 'PLAN_VERSION'
3189: and pfo.fin_plan_preference_code = p_fin_plan_preference_code