DBA Data[Home] [Help]

APPS.ENG_DEFAULT_ECO dependencies on ENG_TYPE_ORG_HIERARCHIES

Line 370: FROM ENG_TYPE_ORG_HIERARCHIES

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