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.

[Home] [Help]

APPS.PA_FP_VIEW_PLANS_UTIL dependencies on PA_PROJ_FP_OPTIONS

Line 721: from pa_proj_fp_options

717: 'REVENUE'),
718: 'COST'))
719: into l_amount_set_id,
720: l_budget_version_type
721: from pa_proj_fp_options
722: where fin_plan_version_id = p_budget_version_id and
723: fin_plan_option_level_code = 'PLAN_VERSION';
724: -- IF WE FIND NO AMOUNT SET, then we cannot query amount sets table, so throw error
725: if l_amount_set_id = -1 then

Line 5152: l_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;

5148: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
5149:
5150: l_group_resource_type_id pa_resource_lists.group_resource_type_id%TYPE;
5151: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE; -- bug 3081511
5152: l_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
5153: l_prj_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
5154: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
5155: l_version_type pa_budget_versions.version_type%TYPE;
5156: l_resource_level VARCHAR2(1); -- used to store temp value of return variable

Line 5154: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

5150: l_group_resource_type_id pa_resource_lists.group_resource_type_id%TYPE;
5151: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE; -- bug 3081511
5152: l_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
5153: l_prj_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
5154: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
5155: l_version_type pa_budget_versions.version_type%TYPE;
5156: l_resource_level VARCHAR2(1); -- used to store temp value of return variable
5157: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
5158:

Line 5216: from pa_proj_fp_options po,

5212: bv.version_type
5213: into l_proj_fp_options_id,
5214: l_fin_plan_level_code,
5215: l_version_type
5216: from pa_proj_fp_options po,
5217: pa_budget_versions bv
5218: where bv.budget_version_id = p_budget_version_id and
5219: bv.budget_version_id = po.fin_plan_version_id and
5220: po.fin_plan_option_level_code = 'PLAN_VERSION';