APPS.PER_POSITION_STRUCTURES_PKG dependencies on PER_SECURITY_PROFILES

Line 49: from per_security_profiles psp

45: select psp.view_all_positions_flag
46: , psp.security_profile_id
47: into p_view_all_poss
48: , p_security_profile_id
49: from per_security_profiles psp
50: -- where psp.security_profile_id = hr_security.get_security_profile
51: where psp.security_profile_id = fnd_profile.value('PER_SECURITY_PROFILE_ID')
52: and (psp.business_group_id + 0 = p_Business_group_id
53: or psp.business_group_id is null);

Line 166: from per_security_profiles sec

162: into l_exists
163: from sys.dual
164: where exists (
165: select null
166: from per_security_profiles sec
167: where sec.business_group_id + 0 = X_Business_Group_Id
168: and sec.position_structure_id = X_Position_Structure_Id);
169: --
170: fnd_message.set_name('PAY','PAY_7694_PER_NO_DEL_STRUCTURE');

Line 577: from per_security_profiles sp

573: select null
574: into l_dummy
575: from sys.dual
576: where exists( select 1
577: from per_security_profiles sp
578: where sp.position_id is not null
579: and sp.business_group_id + 0 = p_business_group_id
580: and exists (select null
581: from per_pos_structure_versions psv