APPS.ENGPKIMP dependencies on ENG_CHANGE_ORDER_TYPES

Line 1633: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;

1629: l_plsql_block VARCHAR2(1000);
1630: l_api_caller VARCHAR2(3) := 'CP';
1631:
1632: -- Bug 6982970 vggarg declared this variable start
1633: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;
1634: -- Bug 6982970 vggarg end
1635:
1636: l_err_tbl Error_Handler.Mesg_Token_Tbl_Type;
1637:

Line 8163: eng_change_order_types cot

8159: --- Bug 6982970 vggarg code added for status change business event fire start
8160: SELECT cot.base_change_mgmt_type_code
8161: INTO l_base_cm_type_code
8162: FROM eng_engineering_changes ec,
8163: eng_change_order_types cot
8164: WHERE ec.change_id = item.change_id
8165: AND ec.change_mgmt_type_code = cot.change_mgmt_type_code
8166: AND cot.type_classification = 'CATEGORY';
8167: