DBA Data[Home] [Help]

APPS.ENG_DEFAULT_ECO dependencies on PER_ORGANIZATION_STRUCTURES

Line 322: FROM per_organization_structures pos

318: cp_change_type_id IN NUMBER,
319: cp_organization_id IN NUMBER
320: ) IS
321: SELECT pos.organization_structure_id, pos.NAME
322: FROM per_organization_structures pos
323: WHERE pos.organization_structure_id in (SELECT hierarchy_id
324: FROM ENG_TYPE_ORG_HIERARCHIES
325: WHERE change_type_id = cp_change_type_id
326: AND organization_id = cp_organization_id