APPS.PA_RBS_UTILS dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 2493: FROM pa_resource_lists_all_bg

2489: decode(group_resource_type_id,103, 'ORGANIZATION',
2490: decode(group_resource_type_id, 108, 'EXPENDITURE_CATEGORY',
2491: decode(group_resource_type_id, 109, 'REVENUE_CATEGORY',
2492: 'NONE'))) group_res_type
2493: FROM pa_resource_lists_all_bg
2494: WHERE resource_list_id = p_resource_list_id;
2495: -- AND nvl(uncategorized_flag, 'N') <> 'Y';
2496:
2497: CURSOR get_lists_names (p_resource_list_id NUMBER) IS

Line 2532: EXISTS (SELECT 'Y' FROM pa_resource_lists_all_bg

2528: child.revenue_category
2529: FROM pa_resource_list_members child
2530: WHERE child.resource_list_id = p_resource_list_id
2531: AND ((child.parent_member_id IS NOT NULL AND
2532: EXISTS (SELECT 'Y' FROM pa_resource_lists_all_bg
2533: WHERE resource_list_id = p_resource_list_id
2534: AND group_resource_type_id in (108, 109, 103)))
2535: OR (child.parent_member_id IS NULL AND
2536: EXISTS (SELECT 'Y' FROM pa_resource_lists_all_bg

Line 2536: EXISTS (SELECT 'Y' FROM pa_resource_lists_all_bg

2532: EXISTS (SELECT 'Y' FROM pa_resource_lists_all_bg
2533: WHERE resource_list_id = p_resource_list_id
2534: AND group_resource_type_id in (108, 109, 103)))
2535: OR (child.parent_member_id IS NULL AND
2536: EXISTS (SELECT 'Y' FROM pa_resource_lists_all_bg
2537: WHERE resource_list_id = p_resource_list_id
2538: AND group_resource_type_id not in (108, 109, 103))))
2539: AND migration_code = 'M'
2540: AND resource_type_id not in (110, 107)

Line 2823: -- Stamp frozen version ID on pa_resource_lists_all_bg

2819: fnd_global.user_id,
2820: fnd_global.login_id);
2821: END LOOP; -- End RBS V TL names Loop Version
2822:
2823: -- Stamp frozen version ID on pa_resource_lists_all_bg
2824:
2825: -- IF l_status = 'FROZEN' THEN
2826: UPDATE pa_resource_lists_all_bg
2827: SET migrated_rbs_version_id = l_rbs_version_id

Line 2826: UPDATE pa_resource_lists_all_bg

2822:
2823: -- Stamp frozen version ID on pa_resource_lists_all_bg
2824:
2825: -- IF l_status = 'FROZEN' THEN
2826: UPDATE pa_resource_lists_all_bg
2827: SET migrated_rbs_version_id = l_rbs_version_id
2828: WHERE resource_list_id = l_list.resource_list_id;
2829: -- END IF;
2830: