DBA Data[Home] [Help]

APPS.PA_PROJ_FP_OPTIONS_PUB dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 2715: l_uncategorized_res_id pa_resource_lists_all_bg.RESOURCE_LIST_ID%TYPE;

2711:
2712: l_cost_amount_set_id pa_proj_fp_options.COST_AMOUNT_SET_ID%TYPE;
2713: l_revenue_amount_set_id pa_proj_fp_options.REVENUE_AMOUNT_SET_ID%TYPE;
2714: l_all_amount_set_id pa_proj_fp_options.ALL_AMOUNT_SET_ID%TYPE;
2715: l_uncategorized_res_id pa_resource_lists_all_bg.RESOURCE_LIST_ID%TYPE;
2716:
2717: -- Bug :- 2625872, changed l_multi_curr_flag from constant to variable
2718: --l_multi_curr_flag CONSTANT pa_proj_fp_options.PLAN_IN_MULTI_CURR_FLAG%TYPE := 'N';
2719: l_multi_curr_flag pa_proj_fp_options.PLAN_IN_MULTI_CURR_FLAG%TYPE := 'N';

Line 2818: FROM pa_resource_lists_all_bg R1,

2814:
2815: BEGIN
2816: SELECT R1.resource_list_id
2817: INTO l_uncategorized_res_id
2818: FROM pa_resource_lists_all_bg R1,
2819: pa_implementations_all pim,
2820: pa_projects_all prj
2821: WHERE prj.project_id = p_target_project_id
2822: AND pim.org_id = prj.org_id