DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on PER_ORGANIZATION_STRUCTURES

Line 4087: FROM per_organization_structures hier

4083: AND eohp.change_type_org_hierarchy_id = etoh.change_type_org_hierarchy_id
4084: AND etoh.change_type_id = eec.change_order_type_id
4085: AND etoh.organization_id = p_organization_id
4086: AND EXISTS (SELECT 1
4087: FROM per_organization_structures hier
4088: WHERE hier.name = p_org_hierarchy_name
4089: AND etoh.hierarchy_id = hier.organization_structure_id);
4090:
4091: -- cursor to fetch the status in which the change is to be initialized

Line 4478: FROM per_organization_structures

4474: FROM ENG_TYPE_ORG_HIERARCHIES
4475: WHERE change_type_id = l_change_type_id
4476: AND organization_id = p_organization_id
4477: AND hierarchy_id = (SELECT organization_structure_id
4478: FROM per_organization_structures
4479: WHERE name = p_org_hierarchy_name));
4480: EXCEPTION
4481: WHEN NO_DATA_FOUND THEN
4482: l_sched_immediately := 0;