39: --
40: cursor csr_sec_grp is
41: select pbg.security_group_id
42: from per_business_groups pbg
43: , hr_de_organization_links ord
44: where ord.organization_link_id = p_organization_link_id
45: and pbg.business_group_id = ord.business_group_id;
46: --
47: -- Declare local variables
99: --
100: cursor csr_leg_code is
101: select pbg.legislation_code
102: from per_business_groups pbg
103: , hr_de_organization_links ord
104: where ord.organization_link_id = p_organization_link_id
105: and pbg.business_group_id = ord.business_group_id;
106: --
107: -- Declare local variables
945: -- b) During insert.
946: --
947: hr_dflex_utility.ins_or_upd_descflex_attribs
948: (p_appl_short_name => 'PER'
949: ,p_descflex_name => 'HR_DE_ORGANIZATION_LINKS'
950: ,p_attribute_category => p_rec.attribute_category
951: ,p_attribute1_name => 'ATTRIBUTE1'
952: ,p_attribute1_value => p_rec.attribute1
953: ,p_attribute2_name => 'ATTRIBUTE2'