DBA Data[Home] [Help]

APPS.ENG_ECO_PVT dependencies on ENG_CHANGE_ORDER_TYPES_VL

Line 14147: FROM eng_engineering_changes eec, eng_change_order_types_vl ecot

14143: -- Start Changes
14144:
14145: CURSOR check_co_type ( p_change_notice VARCHAR2, p_organization_id NUMBER) IS
14146: SELECT ecot.type_name CHANGE_ORDER_TYPE, eec.assignee_id
14147: FROM eng_engineering_changes eec, eng_change_order_types_vl ecot
14148: WHERE eec.change_notice =p_change_notice
14149: AND eec.organization_id = p_organization_id
14150: AND eec.change_order_type_id = ecot.change_order_type_id;
14151: