APPS.PER_PST_BUS dependencies on PER_POSITION_STRUCTURES

Line 60: from per_position_structures

56: -- Declare cursor
57: --
58: cursor csr_pos_name is
59: select position_structure_id, business_group_id
60: from per_position_structures
61: where name = p_name;
62: begin
63: --
64: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 113: from per_position_structures

109: -- Declare cursor
110: --
111: cursor csr_pos_primary is
112: select position_structure_id,business_group_id
113: from per_position_structures
114: where primary_position_flag = 'Y';
115: begin
116: --
117: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 231: , per_position_structures pst

227: --
228: cursor csr_sec_grp is
229: select pbg.security_group_id
230: from per_business_groups pbg
231: , per_position_structures pst
232: where pst.position_structure_id = p_position_structure_id
233: and pbg.business_group_id = pst.business_group_id;
234: --
235: -- Declare local variables

Line 291: , per_position_structures pst

287: --
288: cursor csr_leg_code is
289: select pbg.legislation_code
290: from per_business_groups pbg
291: , per_position_structures pst
292: where pst.position_structure_id = p_position_structure_id
293: and pbg.business_group_id = pst.business_group_id;
294: --
295: -- Declare local variables

Line 439: ,p_descflex_name => 'PER_POSITION_STRUCTURES'

435: -- b) During insert.
436: --
437: hr_dflex_utility.ins_or_upd_descflex_attribs
438: (p_appl_short_name => 'PER'
439: ,p_descflex_name => 'PER_POSITION_STRUCTURES'
440: ,p_attribute_category => p_rec.attribute_category
441: ,p_attribute1_name => 'ATTRIBUTE1'
442: ,p_attribute1_value => p_rec.attribute1
443: ,p_attribute2_name => 'ATTRIBUTE2'