DBA Data[Home] [Help]

APPS.ENG_DEFAULT_ECO dependencies on ENG_TYPE_ORG_HIERARCHIES

Line 324: FROM ENG_TYPE_ORG_HIERARCHIES

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
327: AND default_hierarchy_flag = 'Y');
328: BEGIN