DBA Data[Home] [Help]

APPS.PER_POSITION_STRUCTURES_PKG dependencies on PER_POS_STRUCTURE_VERSIONS

Line 147: from per_pos_structure_versions psv

143: into l_exists
144: from sys.dual
145: where exists(
146: select 1
147: from per_pos_structure_versions psv
148: where psv.position_structure_id = X_Position_Structure_Id);
149: --
150: fnd_message.set_name('PAY','HR_6084_PO_POS_HAS_HIER_VER');
151: fnd_message.raise_error;

Line 581: from per_pos_structure_versions psv

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
582: where psv.business_group_id = p_business_group_id
583: and not exists
584: ( select null
585: from per_pos_Structure_elements pse