APPS.HR_USER_ACCT_INTERNAL dependencies on FND_SECURITY_GROUPS

Line 849: ,p_sec_group_id in fnd_security_groups.security_group_id%type

845: -- ----------------------------------------------------------------------------
846: --
847: PROCEDURE create_sec_profile_asg
848: (p_user_id in fnd_user.user_id%type
849: ,p_sec_group_id in fnd_security_groups.security_group_id%type
850: ,p_sec_profile_id in per_security_profiles.security_profile_id%type
851: ,p_resp_key in fnd_responsibility.responsibility_key%type
852: ,p_resp_app_id in
853: per_sec_profile_assignments.responsibility_application_id%type

Line 870: FROM fnd_security_groups

866: WHERE user_id = p_user_id;
867: --
868: CURSOR lc_get_sec_group_id IS
869: SELECT security_group_id
870: FROM fnd_security_groups
871: WHERE security_group_id = p_sec_group_id;
872: --
873: CURSOR lc_get_sec_profile IS
874: SELECT security_profile_id

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

941: IF lc_get_sec_group_id%NOTFOUND
942: THEN
943: CLOSE lc_get_sec_group_id;
944: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
945: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');
946: fnd_message.set_token('COLUMN', 'SECURITY_GROUP_ID');
947: fnd_message.set_token('VALUE', to_char(p_sec_group_id));
948: hr_utility.raise_error;
949: ELSE