58: into l_records_found
59: FROM DUAL
60: WHERE EXISTS
61: (SELECT 1
62: FROM MTL_TRANSACTION_LOT_NUMBERS
63: WHERE TRANSACTION_SOURCE_TYPE_ID = 5
64: AND TRANSACTION_SOURCE_ID = arg_wip_entity_id );
65:
66: if (l_records_found <> 0) then
63: WHERE TRANSACTION_SOURCE_TYPE_ID = 5
64: AND TRANSACTION_SOURCE_ID = arg_wip_entity_id );
65:
66: if (l_records_found <> 0) then
67: arg_table_name := arg_table_name||' MTL_TRANSACTION_LOT_NUMBERS *';
68: l_flag := FALSE;
69: end if;
70:
71: l_stmt_num := 340;