APPS.PA_FP_VIEW_PLANS_UTIL dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 5157: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%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:
5159: cursor c1(c_fp_opt_id number,
5160: c_ver_type varchar2) is
5161: select fpe.task_id,

Line 5189: pa_resource_lists_all_bg rl

5185: into l_group_resource_type_id,
5186: l_uncategorized_flag,
5187: l_resource_list_id
5188: from pa_budget_versions bv,
5189: pa_resource_lists_all_bg rl
5190: where bv.budget_version_id = p_budget_version_id
5191: and bv.resource_list_id = rl.resource_list_id;
5192:
5193: if l_group_resource_type_id = 0 then