APPS.PER_PSV_BUS dependencies on PER_POSITION_STRUCTURES

Line 33: from per_position_structures

29: hr_utility.set_location('Entering:'|| l_proc, 10);
30: --
31: select business_group_id
32: into p_business_group_id
33: from per_position_structures
34: where p_position_structure_id = position_structure_id;
35:
36: --
37: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 393: where not exists (select 'Y' from per_position_structures where position_structure_id = p_position_structure_id);

389: ) IS
390: l_proc VARCHAR2(72) := g_package||'chk_position_structure_id';
391: cursor csr_pos_str IS
392: select 'N' from dual
393: where not exists (select 'Y' from per_position_structures where position_structure_id = p_position_structure_id);
394: begin
395: --
396: hr_utility.set_location('Entering:'|| l_proc, 10);
397: --