APPS.HR_SIGNON dependencies on PER_BUSINESS_GROUPS

Line 45: -- The business group is derived by querying PER_BUSINESS_GROUPS

41: -- two ways:
42: --
43: -- ENABLE_SECURITY_GROUPS = 'Y'
44: -- Multi security groups can be used for the same responsibility.
45: -- The business group is derived by querying PER_BUSINESS_GROUPS
46: -- with the security group that the user selected at signon.
47: --
48: -- ENABLE_SECURITY_GROUPS = 'N'
49: -- Single security group model is in use, so the business group

Line 79: FROM per_business_groups

75:
76: BEGIN
77: SELECT business_group_id
78: INTO l_business_group_id
79: FROM per_business_groups
80: WHERE security_group_id = to_char(p_security_group_id);
81:
82: hr_utility.set_location('l_business_group_id: '||l_business_group_id,20);
83: --fnd_log.string(1,'HR','l_business_group_id: '||l_business_group_id);

Line 142: FROM per_business_groups

138: --
139: CURSOR c_chk_bg_locked (l_business_group_id IN NUMBER)
140: IS
141: SELECT 'Y'
142: FROM per_business_groups
143: WHERE security_group_id = to_char(p_security_group_id)
144: AND business_group_id = l_business_group_id;
145: --
146: l_bg_lockout NUMBER DEFAULT NULL;

Line 379: -- per_business_groups view for any business groups (other than the

375: -- This is done by primarily checking the profile
376: -- ENABLE_SECURITY_GROUPS. If this is set then an additional check
377: -- is made to ensure that the enable security groups concurrent
378: -- program has been run - this is done by querying the
379: -- per_business_groups view for any business groups (other than the
380: -- setup business group) with a security_group_id of 0.
381: -- Note: any business groups created whilst security groups are not
382: -- enabled have a default value of 0.
383: --

Line 393: FROM per_business_groups

389: --
390: CURSOR c_check_sec_process_run
391: IS
392: SELECT 'Y'
393: FROM per_business_groups
394: WHERE business_group_id <> 0
395: AND security_group_id = '0';
396: --
397: BEGIN