APPS.PER_ORS_BUS dependencies on PER_ORGANIZATION_STRUCTURES

Line 32: from per_organization_structures

28: -- Declare cursor
29: --
30: cursor csr_org_name is
31: select organization_structure_id, business_group_id
32: from per_organization_structures
33: where name = p_name;
34: begin
35: --
36: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 225: from per_organization_structures

221: -- Declare cursor
222: --
223: cursor csr_org_pos is
224: select organization_structure_id,business_group_id
225: from per_organization_structures
226: where position_control_structure_flg = 'Y'
227: and business_group_id = p_business_group_id;
228: begin
229: --

Line 267: from per_organization_structures

263: -- Declare cursor
264: --
265: cursor csr_org_primary is
266: select organization_structure_id,business_group_id
267: from per_organization_structures
268: where primary_structure_flag = 'Y';
269: begin
270: --
271: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 305: , per_organization_structures ors

301: --
302: cursor csr_sec_grp is
303: select pbg.security_group_id
304: from per_business_groups pbg
305: , per_organization_structures ors
306: where ors.organization_structure_id = p_organization_structure_id
307: and pbg.business_group_id = ors.business_group_id;
308: --
309: -- Declare local variables

Line 366: , per_organization_structures ors

362: --
363: cursor csr_leg_code is
364: select pbg.legislation_code
365: from per_business_groups pbg
366: , per_organization_structures ors
367: where ors.organization_structure_id = p_organization_structure_id
368: and pbg.business_group_id (+) = ors.business_group_id;
369: --
370: -- Declare local variables

Line 514: ,p_descflex_name => 'PER_ORGANIZATION_STRUCTURES'

510: -- b) During insert.
511: --
512: hr_dflex_utility.ins_or_upd_descflex_attribs
513: (p_appl_short_name => 'PER'
514: ,p_descflex_name => 'PER_ORGANIZATION_STRUCTURES'
515: ,p_attribute_category => p_rec.attribute_category
516: ,p_attribute1_name => 'ATTRIBUTE1'
517: ,p_attribute1_value => p_rec.attribute1
518: ,p_attribute2_name => 'ATTRIBUTE2'