DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on PER_ORGANIZATION_STRUCTURES

Line 3962: FROM per_organization_structures hier

3958: AND eohp.change_type_org_hierarchy_id = etoh.change_type_org_hierarchy_id
3959: AND etoh.change_type_id = eec.change_order_type_id
3960: AND etoh.organization_id = p_organization_id
3961: AND EXISTS (SELECT 1
3962: FROM per_organization_structures hier
3963: WHERE hier.name = p_org_hierarchy_name
3964: AND etoh.hierarchy_id = hier.organization_structure_id);
3965:
3966: -- cursor to fetch the status in which the change is to be initialized

Line 4353: FROM per_organization_structures

4349: FROM ENG_TYPE_ORG_HIERARCHIES
4350: WHERE change_type_id = l_change_type_id
4351: AND organization_id = p_organization_id
4352: AND hierarchy_id = (SELECT organization_structure_id
4353: FROM per_organization_structures
4354: WHERE name = p_org_hierarchy_name));
4355: EXCEPTION
4356: WHEN NO_DATA_FOUND THEN
4357: l_sched_immediately := 0;