DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on ENG_TYPE_ORG_HIERARCHIES

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

3950: l_schedule_immediately ENG_ORG_HIERARCHY_POLICIES.SCHEDULE_IMMEDIATELY_FLAG%TYPE;
3951: l_new_status_type NUMBER;
3952: CURSOR c_get_schedule_enabled IS
3953: SELECT eohp.SCHEDULE_IMMEDIATELY_FLAG
3954: FROM ENG_ORG_HIERARCHY_POLICIES eohp, ENG_TYPE_ORG_HIERARCHIES etoh, eng_engineering_changes eec
3955: WHERE eec.change_id = p_local_change_id
3956: AND eohp.organization_id = eec.organization_id
3957: AND eohp.SCHEDULE_IMMEDIATELY_FLAG = 'Y'
3958: AND eohp.change_type_org_hierarchy_id = etoh.change_type_org_hierarchy_id

Line 4349: FROM ENG_TYPE_ORG_HIERARCHIES

4345: WHERE organization_id = p_local_organization_id
4346: AND SCHEDULE_IMMEDIATELY_FLAG = 'Y'
4347: AND change_type_org_hierarchy_id =
4348: (SELECT change_type_org_hierarchy_id
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