DBA Data[Home] [Help]

APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 10763: l_res_list_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%TYPE;

10759:
10760: budget_version_info_rec budget_version_info_cur%ROWTYPE;
10761:
10762: -- added for bug 4724017:
10763: l_res_list_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%TYPE;
10764:
10765: BEGIN
10766:
10767: x_msg_count := 0;

Line 10984: FROM pa_resource_lists_all_bg

10980: END IF;
10981: BEGIN
10982: SELECT nvl(uncategorized_flag,'N')
10983: INTO l_res_list_uncategorized_flag
10984: FROM pa_resource_lists_all_bg
10985: WHERE resource_list_id = budget_version_info_rec.resource_list_id;
10986:
10987: IF l_debug_mode = 'Y' THEN
10988: pa_debug.g_err_stage:='l_res_list_uncategorized_flag: ' || l_res_list_uncategorized_flag;

Line 11515: FROM pa_resource_lists_all_bg

11511: INTO l_resource_list_member_id_tbl
11512: FROM pa_resource_list_members prl,
11513: PA_PLAN_RES_DEFAULTS pr, /*7291493*/
11514: (SELECT control_flag
11515: FROM pa_resource_lists_all_bg
11516: WHERE resource_list_id = version_info_rec.resource_list_id) rl_control_flag
11517: WHERE resource_list_id = version_info_rec.resource_list_id
11518: AND ((rl_control_flag.control_flag = 'N' AND
11519: prl.object_type = 'PROJECT' AND