DBA Data[Home] [Help]

APPS.PA_CAPITALIZED_INTEREST dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 13: FROM per_org_structure_elements

9: IS
10: CURSOR org_cursor(ver_id NUMBER, org_id NUMBER)
11: IS
12: SELECT organization_id_child, organization_id_parent
13: FROM per_org_structure_elements
14: CONNECT BY PRIOR organization_id_child = organization_id_parent
15: AND org_structure_version_id = ver_id
16: START WITH organization_id_parent = org_id
17: AND org_structure_version_id = ver_id;