DBA Data[Home] [Help]

APPS.PER_RI_CONFIG_MAIN dependencies on PER_ENT_SECURITY_GROUPS

Line 201: select enterprise_id into l_enterprise_id from per_ent_security_groups

197: end if;
198:
199:
200: BEGIN
201: select enterprise_id into l_enterprise_id from per_ent_security_groups
202: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
203: EXCEPTION
204: WHEN NO_DATA_FOUND THEN
205: l_enterprise_id := null;

Line 876: select enterprise_id into l_enterprise_id from per_ent_security_groups

872: end if;
873:
874:
875: BEGIN
876: select enterprise_id into l_enterprise_id from per_ent_security_groups
877: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
878: EXCEPTION
879: WHEN NO_DATA_FOUND THEN
880: l_enterprise_id := null;

Line 886: select 'C::'||enterprise_label into l_label from per_ent_security_groups

882: hr_utility.set_location('Enterprise Id is ' || l_enterprise_id, 78);
883: hr_utility.set_location('BEFORE SEC GROUP ID IS : '||fnd_global.security_group_id, 78);
884: l_old_sec_group_id := fnd_global.security_group_id;
885: BEGIN
886: select 'C::'||enterprise_label into l_label from per_ent_security_groups
887: where security_group_id = fnd_global.security_group_id;
888: hr_utility.set_location('Sec Group Id is '||fnd_global.security_group_id, 100) ;
889: EXCEPTION
890: WHEN NO_DATA_FOUND THEN