DBA Data[Home] [Help]

APPS.HR_DE_TAX_SUPPORT dependencies on PER_ORG_STRUCTURE_VERSIONS_V

Line 41: from per_org_structure_elements ose, per_org_structure_versions_v posv

37: ,P_TOP_ORG NUMBER
38: ,P_ORG_HIERARCHY NUMBER)
39: is
40: select distinct ose.organization_id_child organization_id
41: from per_org_structure_elements ose, per_org_structure_versions_v posv
42: where ose.org_structure_version_id = posv.ORG_STRUCTURE_VERSION_ID
43: and ose.BUSINESS_GROUP_ID = posv.BUSINESS_GROUP_ID
44: and posv.ORG_STRUCTURE_VERSION_ID = P_ORG_HIERARCHY
45: and posv.ORGANIZATION_STRUCTURE_ID = P_ORG_HIERARCHY