DBA Data[Home] [Help]

APPS.ENG_ECO_PVT dependencies on ENG_CHANGE_ORDER_TYPES_VL

Line 14221: FROM eng_engineering_changes eec, eng_change_order_types_vl ecot

14217: -- Start Changes
14218:
14219: CURSOR check_co_type ( p_change_notice VARCHAR2, p_organization_id NUMBER) IS
14220: SELECT ecot.type_name CHANGE_ORDER_TYPE, eec.assignee_id
14221: FROM eng_engineering_changes eec, eng_change_order_types_vl ecot
14222: WHERE eec.change_notice =p_change_notice
14223: AND eec.organization_id = p_organization_id
14224: AND eec.change_order_type_id = ecot.change_order_type_id;
14225: