APPS.ENG_ATTACHMENT_IMPLEMENTATION dependencies on ENG_CHANGE_ORDER_TYPES

Line 529: FROM eng_engineering_changes eec,eng_change_order_types ecot

525: END IF ;
526:
527: -- Execute following only for attachment approval
528: SELECT ecot.base_change_mgmt_type_code INTO l_base_change_mgmt_type_code
529: FROM eng_engineering_changes eec,eng_change_order_types ecot
530: WHERE eec.change_id = p_change_id
531: AND ecot.change_order_type_id = eec.change_order_type_id;
532:
533: -- insert into swarb values(8, 'change orde type', l_base_change_mgmt_type_code);

Line 1224: from eng_change_order_types

1220: select change_order_type_id into l_change_order_type_id
1221: from eng_engineering_changes
1222: where change_id = p_change_id;
1223: select base_change_mgmt_type_code into l_base_change_mgmt_type_code
1224: from eng_change_order_types
1225: where change_order_type_id = l_change_order_type_id;
1226: if(l_base_change_mgmt_type_code = 'ATTACHMENT_APPROVAL') then
1227: if(p_header_status = G_ENG_APPR_REQUESTED) then
1228: x_attachment_status := G_SUBMITTED_FOR_APPROVAL;