APPS.PA_FP_VIEW_PLANS_UTIL dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 4987: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;

4983: l_prj_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
4984: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
4985: l_version_type pa_budget_versions.version_type%TYPE;
4986: l_resource_level VARCHAR2(1); -- used to store temp value of return variable
4987: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
4988:
4989: cursor c1(c_fp_opt_id number,
4990: c_ver_type varchar2) is
4991: select fpe.task_id,

Line 5019: pa_resource_lists_all_bg rl

5015: into l_group_resource_type_id,
5016: l_uncategorized_flag,
5017: l_resource_list_id
5018: from pa_budget_versions bv,
5019: pa_resource_lists_all_bg rl
5020: where bv.budget_version_id = p_budget_version_id
5021: and bv.resource_list_id = rl.resource_list_id;
5022:
5023: if l_group_resource_type_id = 0 then