DBA Data[Home] [Help]

APPS.ENG_DEFAULT_ECO dependencies on PER_ORGANIZATION_STRUCTURES

Line 368: FROM per_organization_structures pos

364: cp_change_type_id IN NUMBER,
365: cp_organization_id IN NUMBER
366: ) IS
367: SELECT pos.organization_structure_id, pos.NAME
368: FROM per_organization_structures pos
369: WHERE pos.organization_structure_id in (SELECT hierarchy_id
370: FROM ENG_TYPE_ORG_HIERARCHIES
371: WHERE change_type_id = cp_change_type_id
372: AND organization_id = cp_organization_id