DBA Data[Home] [Help]

APPS.PA_ROLE_PROFILES_UTILS dependencies on PER_BUSINESS_GROUPS

Line 26: FROM per_business_groups

22: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
23:
24: CURSOR c_ids IS
25: SELECT business_group_id
26: FROM per_business_groups
27: WHERE name = p_business_group_name;
28: BEGIN
29: IF l_enable_log = 'Y' THEN
30: pa_debug.init_err_stack ('pa_role_profiles_utils.Check_BusGroup_Name_Or_Id');

Line 59: FROM per_business_groups

55: ELSE
56: IF p_business_group_name IS NOT NULL THEN
57: SELECT business_group_id
58: INTO x_business_group_id
59: FROM per_business_groups
60: WHERE name = p_business_group_name;
61: ELSE x_business_group_id := NULL;
62: END IF;
63: END IF;