APPS.HR_USER_ACCT_API dependencies on FND_SECURITY_GROUPS

Line 90: FROM fnd_security_groups

86: --
87: CURSOR lc_get_sec_group_id
88: IS
89: SELECT security_group_id
90: FROM fnd_security_groups
91: WHERE security_group_key = to_char(p_business_group_id);
92: --
93: l_proc varchar2(72) := g_package||'create_user_acct';
94: l_hire_date date default null;

Line 132: l_sec_group_id fnd_security_groups.security_group_id%type := null;

128: l_temp_id number(15) default null;
129: l_status varchar2(2000) default null;
130: l_enable_sec_groups varchar2(2000) default null;
131: l_sec_profile_asg_count number(15) default null;
132: l_sec_group_id fnd_security_groups.security_group_id%type := null;
133:
134: --
135: BEGIN
136: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 572: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');

568: IF lc_get_sec_group_id%NOTFOUND
569: THEN
570: CLOSE lc_get_sec_group_id;
571: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
572: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');
573: fnd_message.set_token('COLUMN', 'SECURITY_GROUP_KEY');
574: fnd_message.set_token('VALUE', to_char(p_business_group_id));
575: hr_utility.raise_error;
576: ELSE