APPS.PER_ORG_STRUCTURES_PKG dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 142: per_org_structure_versions osv

138: select 1 from dual
139: where exists (
140: select 1
141: from per_org_structure_elements ose,
142: per_org_structure_versions osv
143: where osv.org_structure_version_id = ose.org_structure_version_id(+)
144: and (ose.position_control_enabled_flag = 'Y' or
145: osv.topnode_pos_ctrl_enabled_flag = 'Y'));
146:

Line 214: from per_org_structure_versions osv

210: select 1
211: into l_temp
212: from sys.dual
213: where exists( select 1
214: from per_org_structure_versions osv
215: where ( osv.business_group_id + 0 = p_business_group_id
216: or ( osv.business_group_id is null
217: and p_business_group_id is null))
218: and osv.organization_structure_id =

Line 636: from per_org_structure_versions osv

632: and ( sp.business_group_id + 0 = p_business_group_id
633: or ( sp.business_group_id is null
634: and p_business_group_id is null))
635: and exists (select null
636: from per_org_structure_versions osv
637: where ( osv.business_group_id = p_business_group_id
638: or ( osv.business_group_id is null
639: and p_business_group_id is null))
640: and sp.organization_structure_id =