DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on ENG_TYPE_ORG_HIERARCHIES

Line 4079: FROM ENG_ORG_HIERARCHY_POLICIES eohp, ENG_TYPE_ORG_HIERARCHIES etoh, eng_engineering_changes eec

4075: l_schedule_immediately ENG_ORG_HIERARCHY_POLICIES.SCHEDULE_IMMEDIATELY_FLAG%TYPE;
4076: l_new_status_type NUMBER;
4077: CURSOR c_get_schedule_enabled IS
4078: SELECT eohp.SCHEDULE_IMMEDIATELY_FLAG
4079: FROM ENG_ORG_HIERARCHY_POLICIES eohp, ENG_TYPE_ORG_HIERARCHIES etoh, eng_engineering_changes eec
4080: WHERE eec.change_id = p_local_change_id
4081: AND eohp.organization_id = eec.organization_id
4082: AND eohp.SCHEDULE_IMMEDIATELY_FLAG = 'Y'
4083: AND eohp.change_type_org_hierarchy_id = etoh.change_type_org_hierarchy_id

Line 4474: FROM ENG_TYPE_ORG_HIERARCHIES

4470: WHERE organization_id = p_local_organization_id
4471: AND SCHEDULE_IMMEDIATELY_FLAG = 'Y'
4472: AND change_type_org_hierarchy_id =
4473: (SELECT change_type_org_hierarchy_id
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