DBA Data[Home] [Help]

APPS.PA_PROJ_FP_OPTIONS_PUB dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 2760: l_uncategorized_res_id pa_resource_lists_all_bg.RESOURCE_LIST_ID%TYPE;

2756:
2757: l_cost_amount_set_id pa_proj_fp_options.COST_AMOUNT_SET_ID%TYPE;
2758: l_revenue_amount_set_id pa_proj_fp_options.REVENUE_AMOUNT_SET_ID%TYPE;
2759: l_all_amount_set_id pa_proj_fp_options.ALL_AMOUNT_SET_ID%TYPE;
2760: l_uncategorized_res_id pa_resource_lists_all_bg.RESOURCE_LIST_ID%TYPE;
2761:
2762: -- Bug :- 2625872, changed l_multi_curr_flag from constant to variable
2763: --l_multi_curr_flag CONSTANT pa_proj_fp_options.PLAN_IN_MULTI_CURR_FLAG%TYPE := 'N';
2764: l_multi_curr_flag pa_proj_fp_options.PLAN_IN_MULTI_CURR_FLAG%TYPE := 'N';

Line 2863: FROM pa_resource_lists_all_bg R1,

2859:
2860: BEGIN
2861: SELECT R1.resource_list_id
2862: INTO l_uncategorized_res_id
2863: FROM pa_resource_lists_all_bg R1,
2864: pa_implementations_all pim,
2865: pa_projects_all prj
2866: WHERE prj.project_id = p_target_project_id
2867: AND pim.org_id = prj.org_id