APPS.HR_DE_TAX_SUPPORT dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 28: from per_org_structure_versions posv

24: (P_ORG_HIERARCHY NUMBER
25: ,P_DATE_FROM DATE)
26: is
27: select max(posv.org_structure_version_id) org_structure_version_id
28: from per_org_structure_versions posv
29: where posv.organization_structure_id = P_ORG_HIERARCHY
30: and nvl(posv.date_from,P_DATE_FROM) <= P_DATE_FROM
31: and nvl(posv.date_to,TO_DATE('31/12/4712','DD/MM/YYYY')) >= P_DATE_FROM
32: order by posv.org_structure_version_id;

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